Originally posted by: Mendax

Hi ,

Trying to understand the function CURRENDATETIME() in DSTX8.0

How the results are being obtained ? Using DB queries or Java ?

When using Oracle 9i client version , following is the result.

2016-04-13T15:09:38.833+00:00

When using Oracle 10g client version, following is the result.

2016-04-13T08:58:04.879-08:00

Why there is a different in the UTC timezone. Do we need to change any settings ? Please advise.

Thank You !!

Originally posted by: paul.brett

The CURRENTDATETIME() function does not use the database at all.  Instead it makes an operating system call.

If you insert those values into the database, then it is up to database server/client settings that determine how those values are displayed.

Please ask the question on an Oracle forum.

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: RichMcFate

WTX gets it's date/time information directly from the host operating system.  It has nothing to do with a database.

Where are you seeing these values?  If you're seeing them in the database after a map has put the data there, it may simply mean that Oracle 10g supports UTC offsets and that 9i does not.  Maybe check the column definition in Oracle?

Rich McFate

Originally posted by: Mendax

Thanks for your responses, Paul & Rich.

Actually, the setup file has settings "export TZ=GMT0"

This in turn modifies the server timezone settings. That is why,difference in using in CURRENTDATETIME.

All good, now. Thanks for your help.

Thanks!