Re: Datatype in Oracle

The date format in Oracle includes century, year, month, day, hour, minute and second. The format for entering, updating or retrieval depends on nls-settings of your session with the database. Suppose you have an "american" session with the database. To insert a row in a table MYDATE_TAB which contains a date column MYDATE_COL you use: insert into mydate_tab (mydate_col) values ('01-JAN-98');

Ofcourse it's better if you writing your statements independent of any language settings and if you supply the century, like: insert into mydate_tab(mydate_col) values (to_date('01011998','DDMMYYYY'));

Good luck

Jac.

Ken Ho Kwok Fai wrote in message <6vg5c9$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 Wed Oct 07 1998 - 20:58:47 CEST