i wanted to know whether there is any datatype for holding both date& time together.
if i wanted to the entries between 17.01.2005 15.00 to 19.01.2005 5.00 ..
Our query is
.... ...WHERE out_tm BETWEEN from_time AND to_time
AND out_dt BETWEEN from_date AND to_date.
which is not performing as wanted since from time is greater than to time ...
One of the records is having date-time as 18.01.2005 16.00 has to come as per requirements.