Chris Hoover wrote: > I have several columns in my database that are timestamps. My developers > are asking me how to split the timestamp so that they can look at either the > date or at the time portion. > > 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; -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match