Pecheneg 941

Pecheneg 941

  • 1.6k
  • 4
  • 40

Datetime Format problem Between SQL and Access

May 22 2009 4:26 AM
Hey guys!

I got a Windows Form, used on hundreds of computers. It gets some info from my Sql Server, and writing it to the Access Database, and DateTime format of the SQL server is is "dd.MM.yyyy hh:mm:ss"

But every computer's Windows DateTime settings are not the same, for example "yyyy-MM-dd". It effects on Access database, so when it try to insert datetime with SQL DateTime format, my program crashing...

How can i write Access DateTime insert code, independent from any Windows format?