Skip to Content
0
Former Member
Jul 12, 2007 at 11:27 AM

date & time field

373 Views

hi

i wanted to know whether there is any datatype for holding both date& time together.

for example:

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.

Regards,

Nigesh