CURRENT_DATE: Get the date in your session time zone : CURRENT_DATE « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. CURRENT_DATE

CURRENT_DATE: Get the date in your session time zone

SQL>
SQL> --Get the date in your session time zone using the CURRENT_DATE() function
SQL>
SQL> SELECT CURRENT_DATE FROM dual;

CURRENT_DAT
-----------
2006-SEP-16

SQL>
SQL>
           
       

Related examples in the same category