Set script dates to output in dd-mm-yyyy date format

paulgpaulg Posts: 2
Hi All,

Is there any option in SQL Compare that will output a data compare script using a dd-mm-yyyy format instead of yyyy-mm-dd?

For example, when synching date columns, the SQL Compare script will show dates like this: '2010-06-24 12:28:00:000'

I need the dates in this format: '24-06-2010 12:28:00:000'.

I have defaults on some date columns with dates in the dd-mm-yyyy format which conflict with compare scripts. It's not feasible to manually edit the compare scripts.

Any help or suggestions would be appreciated.

Sign In or Register to comment.