Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: T0_DATE() question

Re: T0_DATE() question

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sun, 12 Jul 1998 04:38:41 GMT
Message-ID: <6o9ekf$3pm@bgtnsc03.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US