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.

Report message to a moderator

Previous Topic: modify constraint for on cascade delete
Next Topic: date datatype
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 28 17:50:49 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.