Adding a second to date

Hi All,

I found this interesting in share with you all. There was a requirement where because of timestamp of a date column value, BODS job was getting fail and we had to go update the date value to ADD one second to it. Later the job got completed successfully. Here is the below query for your reference.

select TO_CHAR(sysdate, ‘DD-MON-YYYY HH:MI:SS AM’) NOW, TO_CHAR(sysdate+1/(24*60*60),’DD-MON-YYYY HH:MI:SS AM’) NOW_PLUS_1_SEC from dual;

Hope this is helpful.

Thanks,

Abdulrasheed.

2 Comments

You must be Logged on to comment or reply to a post.

Srinivas Kumar

September 20, 2013 at 2:16 pm

1/(24*60*60) will give us the fraction of the day. adding that to sysdate will increase the day by 1/86400th part which is 1 sec. This is interesting and thanks for sharing.

Former Member

January 20, 2016 at 2:33 pm

Hi,

I've used that method to add seconds before but have been caught out with rounding errors. This was within the SAP DataServices engine rather than in database SQL, i.e. in a script.

Instead I use,

$vDateTimeVariable + num_to_interval(1,'S')

which will add 1 second to the variable.

Adding a second to date

Assigned Tags