Re: formating a select from a timestamp column

stig erikson <stigerikson_nospam_(at)yahoo(dot)se> schrieb:

> 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?

There are any ways. A simple way is to cast the timestamp to a date:

test=# select now();
now
-------------------------------
2005-11-19 09:05:06.750268+01
(1 Zeile)

test=# select now()::date;
now
------------
2005-11-19
(1 Zeile)

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°