Snippet Name: Date functions: CURRENT_DATE Description: The CURRENT_DATE function returns the current date in the session time zone as a value in the Gregorian calendar of datatype DATE. Also see:» FUNCTIONS: date/time » UPDATE: Update a partitioned table » UPDATE: Update based on a record » UPDATE: Update Object Table » UPDATE: with RETURNING clause » UPDATE: Nested Table Update example » UPDATE: Correlated Update » UPDATE: Update from a SELECT statement » UPDATE: based on multiple returned val... » UPDATE: Update based on a query » UPDATE: Update multiple rows » UPDATE: update a specific record » UPDATE: Single row » Date Functions: EXTRACT » Date Functions: TO_DSINTERVAL » Date Functions: TO_NCHAR » Date Functions: TO_YMINTERVAL » Date Functions: Calculate elapsed time... » Date and Time Calculations: Get second... » Date: Find first day of the month » Date Calculations » Date Functions: WHERE Clause Joins » Date Functions: TRUNC » Date Functions: SYSDATE » Date Functions: TO_CHAR » Date Functions: ROUND » Date Functions: NEXT_DAY » Date Functions: NEW_TIME » Date Functions: MONTHS_BETWEEN » Date Functions: MIN Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 03rd, 2009
Description: The CURRENT_DATE function returns the current date in the session time zone as a value in the Gregorian calendar of datatype DATE.
Also see:» FUNCTIONS: date/time » UPDATE: Update a partitioned table » UPDATE: Update based on a record » UPDATE: Update Object Table » UPDATE: with RETURNING clause » UPDATE: Nested Table Update example » UPDATE: Correlated Update » UPDATE: Update from a SELECT statement » UPDATE: based on multiple returned val... » UPDATE: Update based on a query » UPDATE: Update multiple rows » UPDATE: update a specific record » UPDATE: Single row » Date Functions: EXTRACT » Date Functions: TO_DSINTERVAL » Date Functions: TO_NCHAR » Date Functions: TO_YMINTERVAL » Date Functions: Calculate elapsed time... » Date and Time Calculations: Get second... » Date: Find first day of the month » Date Calculations » Date Functions: WHERE Clause Joins » Date Functions: TRUNC » Date Functions: SYSDATE » Date Functions: TO_CHAR » Date Functions: ROUND » Date Functions: NEXT_DAY » Date Functions: NEW_TIME » Date Functions: MONTHS_BETWEEN » Date Functions: MIN
col SESSIONTIMEZONE format a30 SELECT SESSIONTIMEZONE, CURRENT_DATE FROM dual; ALTER SESSION SET TIME_ZONE = '-7:0'; SELECT SESSIONTIMEZONE, CURRENT_DATE FROM dual; ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT SESSIONTIMEZONE, CURRENT_DATE FROM dual; ALTER SESSION SET TIME_ZONE = '-9:0'; SELECT SESSIONTIMEZONE, CURRENT_DATE FROM dual; ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';
