Re: T0_DATE() question

From: David Schweisguth <davids_at_tracy.pangeasystems.com>
Date: 14 Jul 1998 15:53:12 GMT
Message-ID: <6ofut8$eog$1@pornstorm.geo.net>

Jonathan Gennick (gennick_at_worldnet.att.net) wrote:
: 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.

But you can use last_day and add_months to figure out the correct date.

Dave Schweisguth                              Work: davids_at_pangeasystems.com
Pangea Systems                                Home: dschweisguth_at_earthlink.net

Received on Tue Jul 14 1998 - 10:53:12 CDT