combing date and time to do max

[ss7415]

i have date_add and time_add i want combine the two fields and do a max on both combined. sometimes a record may have the same date, so i need the time to determine the max.


first record
date_add looks like 4/13/2006
time_add look like 20342180

second record
date_add looks like 4/13/2006
time_add look like 20532132

 

[gmmastros]

Post your question here: forum1177

The guys in the Oracle forum are almost as sharp as us. I'm sure someone will be able to help you.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom