Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Convert dat time to EN US format

Avatar of isaackhazi
isaackhazi asked on
Microsoft SQL Server.NET ProgrammingVisual Basic.NET
10 Comments1 Solution497 ViewsLast Modified:
I have a VB.NET application with SQL server 2008 as the backend DB.

I live in Thailand so the current date here is :

2553-04-07 14:09:25.000

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

subtract  543 years from the year.
ASKER CERTIFIED SOLUTION
Avatar of rajvja
rajvjaFlag of United Kingdom of Great Britain and Northern Ireland image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answers