OraFAQ Forum: SQL & PL/SQL

Wed, 30 January 2002 06:48

Peter
Messages: 62
Registered: August 2000

Member

HOW DO MOVE A DATE (FOR EXAMPLE SYSDATE) TO THE FIRST WORKING DAY OF THAT MONTH

Wed, 30 January 2002 07:07

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select trunc(sysdate,'mm') from dual;

or

select last_day(add_months(sysdate,-1))+1 from dual

Previous Topic:	utl_file and empty files
Next Topic:	Combine queries !!!

Goto Forum:

]

Current Time: Thu Apr 18 09:46:21 CDT 2024