MySQL DateTime from .Net

 I learn the hard way that different Windows Region settings will screw up your life.

If user has a DateTime region setting not what you have as a devoloper you have to convert DateTime in your .Net program to send DateTime in MySQL format while doing UPDATE or INSERT INTO.

dim myDate as Date

myDate=now

Sending this to MySQL use following format string

INSERT INTO myTable bla bla 

Values ( myDate.ToString("yyyy-MM-dd HH:mm:ss")