how to subtract time
Posted: Tue Oct 30, 2007 6:29 am
AOA
i have field in which date and time store and i want to subtract
time with predefine time how can i do it
eg
select checkin_date-'08:15:00'
from table
checkin_date store both time and date.
i have field in which date and time store and i want to subtract
time with predefine time how can i do it
eg
select checkin_date-'08:15:00'
from table
checkin_date store both time and date.