[EMAIL PROTECTED] ("Chris Hoover") writes:
> 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
Look at the function date_part(time_type, timestamp)
--
(format nil "[EMAIL PROTECTED]" "cbbrowne" "ntlug.org")
http://www3.sympatico.ca/cbbrowne/lsf.html
Do not worry about the bullet that has got your name on it. It will
hit you and it will kill you, no questions asked. The rounds to worry
about are the ones marked: TO WHOM IT MAY CONCERN.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
