You could also try:
select to_char(to_date('01/03/2010','MM/DD/YYYY')+1,'IW') from dual;
I think 'WW' will not give what you want.
Mike
On Mon, Aug 9, 2010 at 9:59 AM, Michael Moore <michaeljmo...@gmail.com>wrote:
> USe WW instead of IW
>
>
> On Mon, Aug 9, 2010 at 9:37 AM, swaroop gowda <swaroop.t...@gmail.com>wrote:
>
>> Hi,
>>
>> I am trying to use following statements
>>
>> select
>> to_char(to_date('01/03/2010', 'MM/DD/YYYY') ,'IW') from dual -- SUNDAY ,
>> *It gives 53*
>>
>> select
>> to_char(to_date('01/04/2010', 'MM/DD/YYYY') ,'IW') from dual --MONDAY, *It
>> gives 01*
>> I need SUNDAY as 01 not 53. Basically I need SUNDAY as start of the week.
>>
>> Please any one can help me in this.
>>
>> --
>> Thanks & Regards
>> Swaroop Thailuru Swamy
>>
>> --
>> You received this message because you are subscribed to the Google
>> Groups "Oracle PL/SQL" group.
>> To post to this group, send email to Oracle-PLSQL@googlegroups.com
>> To unsubscribe from this group, send email to
>> oracle-plsql-unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
>
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
