Subject RE: [firebird-support] Conversion error from string #Timestamp#
Author Svein Erling Tysvær
>Hello Good Morning,
>I’m with one error that I cannot found any help on the internet, and I Hope I could get any help...
>I’m migrating a database to the cloud, but, I’m getting the “conversion error from string #Timestamp#” problem when I’m making the insert on the cloud database.
>The date is like in the format 'YYYY-MM-DD 00:00:00’, the database was created with Dialect 1. I changed it for 3 but the error keep happening.
>Could you help me?

Don't know if it helps, but the datatype DATE in Dialect 1 should be similar to TIMESTAMP in Dialect 3. I'm uncertain whether TIMESTAMP is a valid datatype in Dialect 1 or not. DATE in Dialect 3 only contains the date part, and should not be confused with DATE in Dialect 1.

See http://www.firebirdsql.org/manual/isql-dialects.html for a bit more information.

HTH,
Set