Re: to_char() accepting invalid dates? - Mailing list pgsql-sql

<div class="WordSection1"><p class="MsoNormal" style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt
366.4pt412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span
style="font-size:10.0pt;font-family:"CourierNew";mso-fareast-font-family:"Times New Roman";color:black">ERROR at line
1:</span><pclass="MsoNormal" style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt
458.0pt503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-size:10.0pt;font-family:"Courier
New";mso-fareast-font-family:"TimesNew Roman";color:black">ORA-01839: date not valid for month specified</span><p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">That error is coming on <pre><span
style="color:black">selectto_date('20110231', 'YYYYMMDD') from dual;</span></pre><p class="MsoNormal"> <p
class="MsoNormal">becausethere are not 31 days in February 2011, try this:<p class="MsoNormal"> <p
class="MsoNormal">selectto_date('20110228', 'YYYYMMDD') from dual;<p class="MsoNormal"> <p class="MsoNormal"><b
style="mso-bidi-font-weight:normal"><spanstyle="font-size:12.0pt;font-family:"Bookman Old
Style","serif";mso-fareast-font-family:"TimesNew Roman";mso-no-proof:yes">Jared Thompson</span></b><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Palatino Linotype","serif";mso-fareast-font-family:"Times
NewRoman";mso-no-proof:yes">Internet Operations Group</span><span style="font-family:"Palatino
Linotype","serif";mso-fareast-font-family:"TimesNew Roman";mso-no-proof:yes"></span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"PalatinoLinotype","serif";mso-fareast-font-family:"Times New
Roman";mso-no-proof:yes">Office:678.406.2895</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"PalatinoLinotype","serif";mso-fareast-font-family:"Times New
Roman";mso-no-proof:yes"><ahref="mailto:kyle.dungan@att.com"><span
style="mso-bidi-font-size:11.0pt;color:blue">jt060b@att.com</span></a></span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"PalatinoLinotype","serif";mso-fareast-font-family:"Times New
Roman";mso-no-proof:yes"> </span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Palatino
Linotype","serif";mso-fareast-font-family:"TimesNew Roman";mso-no-proof:yes"> </span><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><i><spanstyle="font-size:10.0pt;font-family:"Times New
Roman","serif";mso-fareast-font-family:"TimesNew Roman";mso-bidi-font-family:"Times New
Roman";color:#1F497D;mso-no-proof:yes">Thise-mail and any files transmitted with it are AT&T property, are
confidential,and are intended solely for the use of the individual or entity to whom this email is addressed. If you
arenot one of the named recipient(s) or otherwise have reason to believe that you have received this message in error,
pleasenotify the sender and delete this message immediately from your computer. Any other use, retention,
dissemination,forwarding, printing, or copying of this e-mail is strictly prohibited.</span></i><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";mso-fareast-font-family:"Times New
Roman";mso-bidi-font-family:"TimesNew Roman";mso-no-proof:yes"></span><p class="MsoNormal"> </div>