DateTime formatting
aaron.bertrand
Posts: 24
Yes, I should be on v5, but I'm stubborn.
And yes, the synchronization scripts generated produce better results.
And no, I don't expect a fix for v(current -1).
However, I just wanted to point out that Data Compare 4 can botch up datetime values, at least in the display.
It turns
2006-05-04 20:30:00.000
into
5/4/2006 8:30:00 PM.000
See the specimen here:
http://www.aaronbertrand.com/RG/data_co ... tetime.gif
v5 does a much better job, but I am going to file an enhancement request separately.
And yes, the synchronization scripts generated produce better results.
And no, I don't expect a fix for v(current -1).
However, I just wanted to point out that Data Compare 4 can botch up datetime values, at least in the display.
It turns
2006-05-04 20:30:00.000
into
5/4/2006 8:30:00 PM.000
See the specimen here:
http://www.aaronbertrand.com/RG/data_co ... tetime.gif
v5 does a much better job, but I am going to file an enhancement request separately.
Comments
I think, since it is an MUI application, it formats the date and time according to your installed location information. You'd probably see a different format for the dates and times if you went into your system's Control Panel->Regional and language options and changed the formatting there.