Re: data type

On Fri, 28 Jun 2002 21:05:33 +0200, "MaxVanLooN" <pregund_at_hotmail.com> 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

The quick way to find your default format is to run the query

SELECT SYSDATE
FROM DUAL
/

Whatever format is returned is your default format. This can vary between SQL*Plus and other tools depending on your environment and initialization scripts. You can use any format you want by using the TO_DATE function, or changing you NLS_DATE_FORMAT

If you are using JDBC with Java, use the sqldate type not the standard date type.

Bill Received on Sat Jun 29 2002 - 00:45:19 CEST