Help. CAn not Convert Time Stamp

[BudiBambang]

Hi all,
I'm using Sybase Sql Anywhere 8.0, and every insert/change record, an error occurs : Can not Convert 1/02/2003 to a Time Stamp.

How to solve the problem, It is an error from sybase ?

Thanks
Budi Bambang

 

[JeanNiBee]

Use the CONVERT() function for the value you are inserting.


-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[johnvai]

Dear Friend:

This problem occurs when you try to change an existing field from a data type to Timestamp datatype and you have put a value in the default value, or you have records in your table that don't fit with your datatype. (Like String)

Or you have to take out the default value or you have to delete all your table records.

Hope this helps