Re: Help: Date type value insertion error ?

Yes, the most rigorous method of course is to include a format always, as relying on a default can be very dangerous (I remember an issue I was having as dba with a server default different from a client. They used a 'default 31-12-99' in a column definition, which went utterly wrong when the table was recreated using an Unix session with a different NLS_DATE_FORMAT. You need to set the registry NLS_DATE_FORMAT in HKLM\softwarre\oracle to the value you have used.
The default is DD-MON-YY.

Hth,

Sybrand Bakker, Oracle DBA

Sohan Mendis <sohanshanil_at_ozemail.com.au> wrote in message news:RHbp4.24449$3b6.102302_at_ozemail.com.au...
> Hi,
>
> I have installed Oracle8i on Solaris 7.0. I coould connect to Oracle
> database from NT machine using ODBC.
>
> But when I try to insert date type value, I am getting not valid month
> error. On the server, I have set the NLS_DATE_FORMAT to DD-MM-YYYY
> HH24:MI-SS.
>
> my query is like,
>
> insert into mytabe values('12-12-2000 12:34:00');
>
> I could run the same query against the same table using ODBC for Solaris.
>
> Why am I having this on client macines. Do I have to set any parameter
> related to database on client machines ?
>
> Any help would be greatly appreciated.
>
> Thanks
>
>
Received on Sat Feb 12 2000 - 08:33:27 CST