Home » RDBMS Server » Server Administration » Re: DATE TRUNCATING
Re: DATE TRUNCATING [message #375032] Thu, 19 July 2001 19:02
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
Previous Topic: Re: DATE TRUNCATING
Next Topic: Re: DATE TRUNCATING
Goto Forum:
  


Current Time: Mon Dec 23 20:39:05 CST 2024