Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
CURRENT_DATE
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>