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
- [GENERAL] Splitting Timestamps Chris Hoover
- Re: [GENERAL] Splitting Timestamps Alvaro Herrera
- Joining dates/times (was Re: [GENERAL] Spl... Ron Johnson
- Re: Joining dates/times (was Re: [GENE... Andreas Kretschmer
- Re: Joining dates/times (was Re: [... Martijn van Oosterhout
- Re: Joining dates/times (was Re: [GENE... Tom Lane
- Re: [GENERAL] Splitting Timestamps A. Kretschmer
- Re: [GENERAL] Splitting Timestamps Reece Hart
- Re: [GENERAL] Splitting Timestamps Chris Browne
- Re: [GENERAL] Splitting Timestamps Curtis Scheer