Different CURRENT_TIMESTAMP and SYSDATE in oracle

by

CURRENT_DATE and CURRENT_TIMESTAMP return the current date and time in the session time zone.

SYSDATE and SYSTIMESTAMP return the system date and time – that is, of the system on which the database resides.

If your client session isn’t in the same timezone as the server the database is on (or says it isn’t anyway, via your NLS settings), mixing the SYS* and CURRENT_* functions will return different values. They are all correct, they just represent different things. It looks like your server is (or thinks it is) in a +4:00 timezone, while your client session is in a +4:30 timezone.

You might also see small differences in the time if the clocks aren’t synchronised, which doesn’t seem to be an issue here.

More Related Contents:

  1. Is it possible to output a SELECT statement from a PL/SQL block?
  2. How to use BOOLEAN type in SELECT statement
  3. Receive an unexpected symbol error in my PLSQL query [closed]
  4. PL SQL UPDATE STATEMENT
  5. Splitting string into multiple rows in Oracle
  6. Search All Fields In All Tables For A Specific Value (Oracle)
  7. What is the string concatenation operator in Oracle?
  8. REGEX to select nth value from a list, allowing for nulls
  9. SQL to generate a list of numbers from 1 to 100
  10. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  11. create table with sequence.nextval in oracle [duplicate]
  12. IF EXISTS condition not working with PLSQL
  13. passing table and column name dynamically using bind variables
  14. Selecting the second row of a table using rownum
  15. Is there any way to flush output from PL/SQL in Oracle?
  16. Update with Join query in Oracle
  17. Sleep function in ORACLE
  18. Solution to “cannot perform a DML operation inside a query”?
  19. PLSQL Insert into with subquery and returning clause
  20. What does the colon sign “:” do in a SQL query?
  21. How to query a CLOB column in Oracle
  22. Oracle (Old?) Joins – A tool/script for conversion?
  23. Advice Using Pivot Table in Oracle
  24. Creating or simulating two dimensional arrays in PL/SQL
  25. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. How to call Oracle MD5 hash function?
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment