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
