Home » SQL & PL/SQL » SQL & PL/SQL » DATES
DATES [message #18406] Wed, 30 January 2002 06:48 Go to next message
Peter
Messages: 62
Registered: August 2000
Member
HOW DO MOVE A DATE (FOR EXAMPLE SYSDATE) TO THE FIRST WORKING DAY OF THAT MONTH
Re: DATES [message #18408 is a reply to message #18406] Wed, 30 January 2002 07:07 Go to previous message
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: Sun Aug 09 19:17:05 CDT 2020