Thursday, June 30, 2022

Query to get Next Month First Day for a given Date in Oracle

SELECT TRUNC (ADD_MONTHS (SYSDATE, 1), 'MON'), TO_CHAR (TRUNC (ADD_MONTHS (SYSDATE, 1), 'MON'), 'DD-MON-RRRR')  FROM DUAL




at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records