Adding a second to date
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.