Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: T0_DATE() question
On Fri, 10 Jul 1998 13:47:44 -0700, Matt Naish
<mattn_at_ecricanada.com> wrote:
>Probably a simple question but how do I make TO_DATE round days if out
>of range.
>
>What I mean is a date entered as Feb 31, 1998 will be stored as March 3,
>1998.
You can't. Feb 31 is an invalid date, and TO_DATE should throw an exception.
Jonathan Received on Sat Jul 11 1998 - 23:38:41 CDT
![]() |
![]() |