Set script dates to output in dd-mm-yyyy date format
paulg
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.
Paul
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.
Paul
