Re: data type
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 28 Jun 2002 20:00:31 GMT
Message-ID: <3D1CC041.4E83B94A_at_exesolutions.com>
Date: Fri, 28 Jun 2002 20:00:31 GMT
Message-ID: <3D1CC041.4E83B94A_at_exesolutions.com>
MaxVanLooN wrote:
> Hi , if I set a data field with *date* data type , in which format I must
> write the date ?
> Sorry for the maybe stupid question :)
> Saludos
>
> Max
>
> --
> ===============================
> " e mai poter bere alla coppa d'un fiato
> ma a piccoli sorsi interrotti..."
> ( Fabrizio De Andrč )
Depends on your character set. Were you in the US I could easily answer 'DD-MON-YYYY' as in 01-JAN-2002.
To determine for your installation:
SELECT *
FROM nls_session_parameters;
and/or
SELECT *
FROM nls_database_parameters;
Daniel Morgan Received on Fri Jun 28 2002 - 22:00:31 CEST