can not convert '01/01/1900 00:00:00' to a Timestamp

I would like to do this
INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00')

I have got this error
"cannot convert 01/01/1900 00:00:00 to a Timestamp"

i try this but I have got the same problem  :    set option
PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss';


thank for your help

[email protected]

No you change the date_order, not the date_format.  Date_format is for
DISPLAY purposes only.

set option date_order='MDY'
If this is via ODBC you must issue this AFTER connecting:

set temporary option date_order='MDY'

--
David Fishburn
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup

EBFs and Whitepapers
http://www.sybase.com/products/mobilewireless/anywhere/

"Emmanuel Vincent"  wrote in message
news:[email protected]...
> I would like to do this
> INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00')
>
> I have got this error
> "cannot convert 01/01/1900 00:00:00 to a Timestamp"
>
> i try this but I have got the same problem  :    set option
> PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss';
>
>
> thank for your help
>
> [email protected]
>
>

[email protected]




"David Fishburn"  a �crit dans le message
news: [email protected]...
> No you change the date_order, not the date_format.  Date_format is for
> DISPLAY purposes only.
>
> set option date_order='MDY'
> If this is via ODBC you must issue this AFTER connecting:
>
> set temporary option date_order='MDY'
>
> --
> David Fishburn
> Sybase - iAnywhere Solutions
> Professional Services
> Please only post to the newsgroup
>
> EBFs and Whitepapers
> http://www.sybase.com/products/mobilewireless/anywhere/
>
> "Emmanuel Vincent"  wrote in message
> news:[email protected]...
> > I would like to do this
> > INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00')
> >
> > I have got this error
> > "cannot convert 01/01/1900 00:00:00 to a Timestamp"
> >
> > i try this but I have got the same problem  :    set option
> > PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss';
> >
> >
> > thank for your help
> >
> > [email protected]
> >
> >
>
>