Knowledge Hub — Technical Document

Generated on 2026-08-28 06:59 | Confidential Client Asset

Date Functions

Published July 26, 2025 By Sai Sree Ram Gundepudi

Date Functions

  • SYSDATE – current system date/time
  • ADD_MONTHS(date, n)
  • MONTHS_BETWEEN(date1, date2)
  • LAST_DAY(date), NEXT_DAY(date, 'MONDAY')
SELECT SYSDATE, ADD_MONTHS(SYSDATE, 2), MONTHS_BETWEEN(SYSDATE, TO_DATE('01-JAN-2020', 'DD-MON-YYYY')) FROM dual;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

Date Functions

Working with Date Functions in MySQL

ExamplesSELECT NOW(); SELECT DATEDIFF('2025-12-31', '2025-01-01'); SELECT DATE_ADD(NOW(), INTERVAL 7 DAY); SELECT DATE_F...