On Sun, Jul 30, 2006 at 10:00:30AM +0200, Andreas Kretschmer wrote: > Ron Johnson <[EMAIL PROTECTED]> 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 the easy way: select '2006/07/29'::date + '10:00:00'::time; No need to do anything odd at all... Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
