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
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