Michael,
This works.
Yes, WW does not work as if start of the year falls in the mid of week it
calculates as 1st week I do not want that.
Thank you so much.
On Mon, Aug 9, 2010 at 12:30 PM, Michael Moore <michaeljmo...@gmail.com>wrote:
> 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
>
--
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
