Home » RDBMS Server » Server Administration » Re: DATE TRUNCATING
Re: DATE TRUNCATING [message #375027] Thu, 19 July 2001 18:09
sanjai
Messages: 8
Registered: July 2001
Junior Member
Hi,
Try this one.
Kavithas query gets u the first and last day of current week..

I just modified it
select sysdate, trunc(sysdate-7, 'W')+1,
trunc(sysdate, 'W')from dual;

regards
Sanjai

Report message to a moderator

Previous Topic: Re: DATE TRUNCATING
Next Topic: Re: DATE TRUNCATING
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 21:09:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.