'Timestamp set at database server and database is UTC, but timestamp is getting loaded as MST in Oracle

Application server is showing date as UTC, database server also showing as UTC. When we are inserting systimestamp in a timestamp column from database server then it is showing as UTC format but if we insert from application server then data is getting loaded in MST timezone.

Need some help to figure out what is the issue.

linuxoracleunixutc


Solution 1:[1]

How do you insert date from application server? Most likely as LOCALTIMESTAMP or CURRENT_TIMESTAMP.

You have several possibilities:

  • Change timezone of your application server to UTC
  • Use SYSTIMESTAMP instead of LOCALTIMESTAMP or CURRENT_TIMESTAMP
  • Insert LOCALTIMESTAMP AT TIME ZONE 'UTC' or SYS_EXTRACT_UTC(LOCALTIMESTAMP)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Wernfried Domscheit

Related Questions