Re: Date Disparity

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Tue, Feb 16, 2010 at 1:47 PM, Jared Still <jkstill_at_gmail.com> wrote:

>
> Anyone else see a problem with this:
>
> 1 select trunc(sysdate,'W'), to_char(trunc(sysdate,'W'),'d')
> 2* from dual
> 13:46:46 ordevdb01.radisys.com - js001292_at_dv11 SQL> /
>
> TRUNC(SYSDATE,'W') T
> ------------------- -
> 02/15/2010 00:00:00 2
>
> 1 row selected.
>
> ie. the first day of the week as per trunc() is the second day of the work
> as per to_char()
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>
>

--
http://www.freelists.org/webpage/oracle-l