stig erikson <stigerikson_nospam_@yahoo.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°
