Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can you change the database time (Sysdate) without changing the OS time?

3144990Dec 23 2015 — edited Jan 1 2016

I saw the archived post:

"How can I change database date/time(Sysdate) without changing OS date? at https://community.oracle.com/message/3471626#3471626 "

That post did not have a good answer unfortunately, and as we are having similar system clock change issues where have an urgent need to do some future and past date/time logic testing, I thought it be worth to try again. Does anyone know how we might accomplish this database date/time change without changing the system clock time of the OS?

Thanks,

Charles

This post has been answered by 3021685 on Dec 29 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2016

Added on Dec 23 2015

#general-database-discussions

7 comments

2,106 views