Postgres Pro
Downloads
Home   >   mailing lists

formating a select from a timestamp column - Mailing list pgsql-novice

From stig erikson
Subject formating a select from a timestamp column
Date
Msg-id dl74of$2b3o$1@news.hub.org
Whole thread Raw
Responses Re: formating a select from a timestamp column  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: formating a select from a timestamp column  (Bruno Wolff III <bruno@wolff.to>)
Re: formating a select from a timestamp column  (Keith Worthington <KeithW@NarrowPathInc.com>)
List pgsql-novice
Tree view 
hi i have a column that is declared as:
datum timestamp DEFAULT ('now'::text)::timestamp(6) with time zone


then i do:
SELECT datum from table;
and get something like: 2005-11-13 00:00:00

i would like the output to be on the format: 2005-11-13
how can i change it?

i use postgresql 8.1

thanks
stig

pgsql-novice by date:

Previous
From: Emiliano Amilcarelli
Date:
Subject: Loop through records
Next
From: cjobbers@optonline.net
Date:
Subject: Logging