Обсуждение: formating a select from a timestamp column
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
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°
On Sun, Nov 13, 2005 at 11:30:33 +0100, stig erikson <stigerikson_nospam_@yahoo.se> wrote: > 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? You could cast it to a date. If these times only represent dates, then you should probably just store dates instead of timestamps. > > i use postgresql 8.1 > > thanks > stig > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
stig erikson wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > Stig, How about just casting it to a date? SELECT datum::date from table; -- Kind Regards, Keith