After executing this SQL in oracle 10g:
SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL
I receive this strange output:
What is cause of the difference in time?
The server time is equal of SYSDATE value
reddy :
\nSYSDATE provides date and time of a server.\nCURRENT_DATE provides date and time of client.(i.e., your system)\nCURRENT_TIMESTAMP provides data and timestamp of a clinet.\n",
2016-04-07T09:24:26
Amir Abe :
Note: SYSDATE - returns only the date, i.e., "yyyy-mm-dd" is not correct. SYSDATE returns the system date of the database server including hours, minutes, and seconds. For example:\nSELECT SYSDATE FROM DUAL; \n\nwill return output similar to the following: 12/15/2017 12:42:39 PM",
2017-12-15T18:57:34
Alex Poole :
CURRENT_DATE and CURRENT_TIMESTAMP return the current date and time in the session time zone.\n\nSYSDATE and SYSTIMESTAMP return the system date and time - that is, of the system on which the database resides.\n\nIf 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.\n\nYou might also see small differences in the time if the clocks aren't synchronised, which doesn't seem to be an issue here.",
2013-07-29T13:49:33
RaMs_YearnsToLearn :
SYSDATE, SYSTIMESTAMP returns the Database's date and timestamp, whereas current_date, current_timestamp returns the date and timestamp of the location from where you work.\n\nFor eg. working from India, I access a database located in Paris. at 4:00PM IST:\n\nselect sysdate,systimestamp from dual; \n This returns me the date and Time of Paris:\n\n\n RESULT\n\n\n12-MAY-14 12-MAY-14 12.30.03.283502000 PM +02:00\n\n\nselect current_date,current_timestamp from dual; \n This returns me the date and Time of India:\n\n\n RESULT\n\n\n12-MAY-14 12-MAY-14 04.00.03.283520000 PM ASIA/CALCUTTA\n\n\nPlease note the 3:30 time difference.",
2014-05-12T10:43:40
Harshit :
SYSDATE returns the system date, of the system on which the database resides\n\nCURRENT_TIMESTAMP returns the current date and time in the session time zone, in a value of datatype TIMESTAMP WITH TIME ZONE\n\nexecute this comman\n\n ALTER SESSION SET TIME_ZONE = '+3:0';\n\n\nand it will provide you the same result.",
2013-07-29T10:57:54