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.