minus 1 hour for a datetime field

dataservices job design
1

Hi, hopefully a quick question, i am using Oracle.

what is the best way of taking a datetime field and subtracting 1 hour, ta.

e.g. would like 24/09/2009 13:42:00 to be 24/09/2009 12:42:00

thanks.

mjs8274 :uk: (BOB member since 2006-04-26)

2

Here is the solution.

select to_date(‘10/14/2009 2:38:53’,‘mm/dd/yyyy hh:mi:ss’) - interval ‘1’ hour from dual;

Hope it helps.

Sri

bodideveloper (BOB member since 2009-08-29)