Home » RDBMS Server » Server Administration » Re: DATE TRUNCATING
Re: DATE TRUNCATING [message #375031] Thu, 19 July 2001 19:00
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: Create Temporay tables in Oracle 8
Next Topic: Re: DATE TRUNCATING
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 12 16:32:18 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.