Skip to Main Content

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!

systimestamp return value with Linux server time set

592815Dec 21 2010 — edited Dec 21 2010
Hi Experts:
Oracle document states as : SYSTIMESTAMP returns the system date, including fractional seconds and time zone, of the system on which the database resides. The return type is TIMESTAMP WITH TIME ZONE.
As I know there are two setting (hardware time and system time ) the linux server. If we do not set hardware time to UTC. or both hardware /system time set to local time.
My question, does oracle database systimestamp return different value in pl/SQL code?

I have a database in linux server there are some data column in tables. if Linux server time setting changes time by time, does database machine time set changes afftect data value during
inset/update data value with oracle systimestamp in database?

does database linux server (PC) time setting affect oracle systimestamp return value?

I know server(PC) affect some front program ( incluse SQLPLUS) return value of building system function
Any wrong?
Thanks explaining?
Jim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2011
Added on Dec 21 2010
11 comments
844 views