the date - time should be 4/13/2006 20:34:21.80
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
i have date_add and time_add i want combine the two fields . sometimes a record may have the same date, so i need the time to determine the max. i would like to do it in my command , im using crystal xi and oracle9i
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
i have date_add and time_add i want combine the two fields . sometimes a record may have the same date, so i need the time to determine the max. i would like to do it in my command , im using crystal xi and oracle9i