RE: Date Disparity

From: Blanchard, William <wblanchard_at_societyinsurance.com>
Date: Tue, 16 Feb 2010 15:52:15 -0600
Message-ID: <CB340D772D072D47A5DE07533432A7E50E80299B_at_exch1.soc.int>

I don't know that that's incorrect. The 15th, Monday, is the second day of the week.    

WGB   From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, February 16, 2010 3:48 PM To: Oracle-L Freelists
Subject: Date Disparity    

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

-

This email and any information, files, or materials transmitted with it are confidential and are solely for the use of the intended recipient. If you have received this email in error, please delete it and notify the sender.

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

Received on Tue Feb 16 2010 - 15:52:15 CST