Home » RDBMS Server » Server Administration » Re: DATE TRUNCATING
Re: DATE TRUNCATING [message #375028] Thu, 19 July 2001 18:55
sanjai
Messages: 8
Registered: July 2001
Junior Member
Hi,
U can also do it in following way

select next_day((select sysdate-14 from dual),'MONDAY'),
next_day((select sysdate-7 from dual),'SUNDAY') from dual;

instead od sysdate u can use any specified date

regards
Sanjai

Report message to a moderator

Previous Topic: Re: DATE TRUNCATING
Next Topic: Create Temporay tables in Oracle 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:33:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.