Subject | RE: [firebird-support] Conversion error from string #Timestamp# |
---|---|
Author | Svein Erling Tysvær |
Post date | 2014-06-12T05:42:51Z |
>Hello Good Morning,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.
>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?
See http://www.firebirdsql.org/manual/isql-dialects.html for a bit more information.
HTH,
Set