Oracle CURRENT_DATE vs SYSDATE

Oracle CURRENT_DATE vs SYSDATE is a SQL function in the Oracle Specific category. Oracle: SYSDATE returns server date/time. CURRENT_DATE returns session timezone date/time. The syntax is CURRENT_DATE / SYSDATE. It accepts see syntax. It returns date/time with timezone. A typical example: SELECT SYSDATE FROM DUAL; -- Server time (always same) SELECT CURRENT_DATE FROM DUAL; -- Session timezone time ALTER SESSION SET TIME_ZONE = 'America/New_York'; SELECT SYSDATE, CURRENT_DATE, SYSTIMESTAMP FROM DUAL; -- SYSDATE: server time (same as before) -- CURRENT_DATE: Eastern Time -- SYSTIMESTAMP: server timestamp with timezone -- SESSIONTIMEZONE: SELECT SESSIONTIMEZONE FROM DUAL; -- DBTIMEZONE (database timezone): SELECT DBTIMEZONE FROM DUAL; -- Useful for global applications: -- Store in TIMESTAMP WITH… A close relative is SEQUENCE (Oracle), which oracle: generates sequential numbers. Independent of tables. Accessed via NEXTVAL and CURRVAL. A close relative is ROWNUM / FETCH FIRST, which oracle: ROWNUM assigns sequential numbers to rows. Used for limiting results (pre-12c).