Re: Joining dates/times (was Re: Splitting Timestamps)
От | Andreas Kretschmer |
---|---|
Тема | Re: Joining dates/times (was Re: Splitting Timestamps) |
Дата | |
Msg-id | 20060730080030.GA32129@KanotixBox обсуждение исходный текст |
Ответ на | Joining dates/times (was Re: Splitting Timestamps) (Ron Johnson <ron.l.johnson@cox.net>) |
Ответы |
Re: Joining dates/times (was Re: Splitting Timestamps)
|
Список | pgsql-general |
Ron Johnson <ron.l.johnson@cox.net> schrieb: > >> I know I can do a select to_date(now(),'yyyy-mm-dd') and it will return the > >> date. However, how do I get the time? Also, is this the proper way to get > >> the date portion of a timestamp? > > > > select now()::timetz; > > select now()::time; > > select now()::date; > > What's the inverse? Say I have a DATE and a TIME, and want to > create a TIMESTAMP with them? You can CAST it: test=# select '2006/07/29 10:00:00'::timestamp; timestamp --------------------- 2006-07-29 10:00:00 (1 row) or: test=# select ('2006/07/29'::date || ' ' || '10:00:00'::time)::timestamp; timestamp --------------------- 2006-07-29 10:00:00 (1 row) HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: