DATE TIME FORMAT ERROR IN SPANISH

SQL Compare Data generate script in datetime fields like... '2019-03-26 07:03:41.190'
but my server in Spanish throws the following error
Mens. 242, Nivel 16, Estado 3, Línea 11
La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.




Tagged:

Answers

  • Hi jedm68,

    Thanks for posting on the Redgate forums.

    I will try and setup a spanish database and see if I can replicate this and then come back to you. 
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Hi jedm68,

    I haven't been able to replicate this one.

    Does the comparison work if you change the database from Spanish to English? Can you give an example of the comparison that should be occurring?
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.