how can i retrieve only the time from a column in pl/sql? my default nls_date_formant is 'dd-mon-yyyy', but when i look at the column in toad, i can see the time. i know it's there, but how do i retrieve it? i want to be able to say:
if <time in column> is greater than <time in sysdate>, so this.
the time in the column will look like: 31-DEC-1899 08:00:00 AM
so i can't just say
if column > sysdate because of the 31-DEC-1899 part. i need to compare only the times. thanks.