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
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
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
TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »Oracle TO_CHAR Example
What is New Line Character in Oracle? Sometimes, we need to make several lines for each row. For example, we'd like to compose some dialogs… Read More »How to Add New Line for Each Row
Oracle TO_DATE function can convert a string into a datetime value which is acceptable for computing or comparing values of datetime type. In other words,… Read More »Oracle TO_DATE Example
SUBSTR Function Oracle SUBSTR function is used to cut or extract a piece of sub-string from an outer string. In this post, I will introduce… Read More »Oracle SUBSTR Function by Examples