Re: VBQ (very basic question) date

In Oracle you cannot specify the format in which a date is stored. Oracle always uses 7 bytes:
Century, Year, Month, Day, Hour, Minute and Second.

The date format is only used for input and display. If you want to change the way you use a date for the database then set NLS_DATE_FORMAT in the init.ora file. If you only want to use it for that particular table then you will have to control it programmatically.

Kenny Gump

bernd1615_at_my-deja.com wrote in message <7ktgj1$7qv$1_at_nnrp1.deja.com>...
>Dear Participants ,
>
>I have some trouble setting the date format:
>
>create table some_table
>( ...
> dat date,
> ... )
>
>I don`t want to take the default date format but something like :
>
> ...
> dat date (DD MON YYYY HH24 MI SS) ,
> ...
>Does someone of you know the correct syntax for that ?
>
>Your insight knowledge will be greatly appreciated !
>
>Markus Banach
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 24 1999 - 15:00:31 CDT