I have a strange date pattern format issue.
In XP, I have set the Data Type formatting to "General date/time with seconds
pattern (G). And in the custom Tab, I set DateTime2 as yyyy/MM/dd
The displayed formatting is 24/08/2010 3:26:46 PM
When I use ‘2010-08-23’ as an input string for a date column, TDA executes and
inserts the field correctly.
In WinServer2003, I set it exactly the same, but the displayed formatting is
8/24/10 3:26:46 PM
And trying to insert ‘2010-08-23’ yields a “Literal does not match input string”
Is there anything in the PC’s local setting that must match? I am trying to
transport a complicated script which uses string patter formation in date
columns from XP to run on the server’s TDA (same build) but I get a “Literal
does not match input string” error for a script that works from my XP box.
rewriting the script to work on the Server would take a lot of time as there are
dozens of date columns involved in nested subqueries.