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?