a given date + 1 hour
789736Aug 1 2012 — edited Aug 1 2012Hi guys,
I have a quick question for ya that I am hoping is not to hard. I currently have a date time field and basically all I want to do is add 1 hour to this field and was wondering if its as simple as doing + 0.041666.
ie , if i select sysdate + 0.041666 from dual that gives me exactly 1 hour from the current datetime, but I was wondering is there a more accurate way to do this or a different method to do this to ensure it is correct? as 1/24 is actually 0.0416666666666666666667 or whatever I am just curious as to if my method is the correct way to do this.
Thanks.