I have a VB.NET application with SQL server 2008 as the backend DB.
I live in Thailand so the current date here is :
Usually all data entry PC have the application installed and the PC's regional setting is set to EN US.
Unfortunately last week the data entry team were doin their job from home and their setting athome was TH instead of EN US.
Now I have around 1000 records with a time stamp with the Thai date instead of the standard date.
How do I update it either in SQl directly oir by writing a small script in VB so that I can change these current date stamps to the current date seeting ENUS
What i need is to convert 2553-04-07 14:09:25.000 -> 2010-04-07 14:09:25.000