Date and Time Problem.
I have a database field (deliver_date) which stores date entered by user.
another two numeric fields(deliver_time_hh, and deliver_time_mm) which stores hh and mm in 24 hr format,
and newly added field (ActualDelivery) which stores date and time with NOW() function e.g. "05/31/2005 01:10:12 PM".
Now, problem is that i have to compate deliver_date,deliver_time_hh, and deliver_time_mm with ActualDelivery and get records in which
estimated is greater then actual. Since comparision has to be made in date and time.
In short, i need to convert deliver_date,deliver_time_hh, and deliver_time_mm to a single date whose formate is same as ActualDelivery and compare to ActualDelivery.
Thanks in advance.
We CAN'T avoid problems, but can solve it.