Re: Datatype in Oracle

From: Van Messner <vmessner_at_netaxis.com>
Date: Sat, 17 Oct 1998 15:58:31 -0400
Message-ID: <fI6W1.55$1e2.655@news14.ispnews.com>

Hi Ken:

Jason is correct. You can set the default date format in your init.ora file or you can change it for a session using the alter session command. This lets you play around with different formats. Oracle's default format of dd-mon-yy may not be the best for your users, if you have year 2000 issues to worry about. Check out dd-mon-yyyy for a permanent solution or dd-mon-rrrr for an interim one.
Van

Ken Ho Kwok Fai wrote in message <6vg5ik$5nb_at_eng-ser1.erg.cuhk.edu.hk>...
>I am using Oracle 7.3.2 in Unix. I want to know the format of the
>datatype "Date". What format I should use to input a date to the database
>which type is "Date"? Another problem is about Boolean type. Do oracle
>support "Boolean" type? Thanks you for your kind attention.
>
>--
>Regards,
>Ken
>
Received on Sat Oct 17 1998 - 14:58:31 CDT