Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to declare type data
"Sergio Cotti" <sergiof31_at_hotmail.com> wrote in message
news:662333daca44ab80bbe563aae491575b.18240_at_mygate.mailgate.org...
> Yes, but i want to known what can i do to declare an data type record.
> es. create table test
> ( data Date.....);
>
> and i want to specify the format of the Date type.
>
> thanks in advance.
> Daniele.
>
>
> --
> Posted from [213.156.38.68]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
You can't specify the format of the date datatype. You can force users to use a specific format in many different fashions, one of them setting the registry var/environment var NLS_DATE_FORMAT to the appropiate value.
Hth,
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Tue Nov 06 2001 - 09:08:40 CST
![]() |
![]() |