Date and Timestamp as per local culture

View All Scripts Login to Run Script

Script Name Date and Timestamp as per local culture
Description This script gives time stamp in Indian style DD-MON-YYYY. Microsoft's default format is MM-DD-YYYY. Indian Standard Time is GMT + 5.30 which is used in this script. Same can be replaced with local time of any other country. Similarly time format can be set as 12 hours or 24 hours as per choice.
Area SQL General / SQL Query
Contributor Date Time
Created Saturday March 10, 2018

Statement 1

SELECT TO_CHAR 
    (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" 
     FROM DUAL


NOW
03-10-2018 06:39:28

NOW
03-10-2018 06:39:28

Statement 2

ALTER SESSION SET TIME_ZONE = '5:30'

Statement processed.

Statement 3

SELECT TO_CHAR 
    (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" 
     FROM DUAL


NOW
03-10-2018 06:40:19

NOW
03-10-2018 06:40:19

Statement 4

ALTER SESSION SET TIME_ZONE = '+5:30'

Statement processed.

Statement 5

SELECT TO_CHAR 
    (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" 
     FROM DUAL


NOW
03-10-2018 06:40:39

NOW
03-10-2018 06:40:39

Statement 6

ALTER SESSION SET TIME_ZONE = '+5:30'

Statement processed.

Statement 7

SELECT TO_CHAR 
    (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" 
     FROM DUAL


NOW
03-10-2018 06:41:10

NOW
03-10-2018 06:41:10

Statement 8

     SELECT SESSIONTIMEZONE, CURRENT_TIMESTAMP FROM DUAL


SESSIONTIMEZONE CURRENT_TIMESTAMP
+05:30 10-MAR-18 12.11.10.684742 PM +05:30

SESSIONTIMEZONE	CURRENT_TIMESTAMP
+05:30	10-MAR-18 12.11.10.684742 PM +05:30

Additional Information