Re: Splitting Timestamps

I believe you would want to cast the field to a date like so select
datefield::datefrom table1 or select datefield::time from table1.

_____

From: Chris Hoover [mailto:revoohc(at)gmail(dot)com]
Sent: Tuesday, July 25, 2006 11:55 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Splitting Timestamps

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?

Thanks,

Chris