Home » SQL & PL/SQL » SQL & PL/SQL » Re: Week to date
Re: Week to date [message #18952] Fri, 22 February 2002 09:53
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
try this:
select to_char(sysdate-to_number(to_char(sysdate,'d'))+&num,'day') from dual

-- num must be 1 to 7.
Previous Topic: modify constraint for on cascade delete
Next Topic: date datatype
Goto Forum:
  


Current Time: Thu Mar 28 10:19:12 CDT 2024