Oracle-L: Re: Valid Dates in Oracle

From: Mark Zawadzki <markz_at_A4420MSD.ESR.HP.COM>
Date: Mon, 5 Feb 1996 09:52:02 EST
Message-Id: <9602051508.AA08971@alice.jcc.com>

yes use functiom "to_date" :

        example : to_date('01-01-0001', 'MM-DD-YYYY')
        or set your default date mask to 'MM-DD-YYYY'
        (Also see ANSI, DB2 and SQL/DS in the SQL Language Reference Manual,
         in mine it resides on page 2-30)'

=
>
> Can I use the dates of 01-01-0001 or 12-31-9999 in an oracle date field?
> (These are common defaults we use in DB2).
> Thanks.
> Jim Mulford
> Database Analyst
> PA Blue Shield
> JFM_at_pa.microserve.com
>
Received on Mon Feb 05 1996 - 10:08:58 CST