How to Check Session Time Zone
SESSIONTIMEZONE While DBTIMEZONE is to check the database time zone, the built-in function SESSIONTIMEZONE is to check the exact time zone in the current session.… Read More »How to Check Session Time Zone
Datetime Function
Derive Timestamp from SYSTIMESTAMP
SYSTIMESTAMP To have a timestamp as of now, we can use the function SYSTIMESTAMP. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 09-AUG-23 04.36.54.934270 PM -04:00… Read More »Derive Timestamp from SYSTIMESTAMP
How to Check Database Time Zone
DBTIMEZONE There're 2 ways to check the time zone of a database. Database Property Since DBTIMEZONE is actually a property of database, we may query… Read More »How to Check Database Time Zone
How to Resolve ORA-01821: date format not recognized
ORA-01821 Tried to display a datetime into a readable format by TO_CHAR function, but it failed with ORA-01821. SQL> set heading off; SQL> select TO_CHAR(sysdate,… Read More »How to Resolve ORA-01821: date format not recognized