Saturday, February 23, 2013

Vb.net convert to MySQL DateTime format

Creating SQL to database servers can be a pain sometimes.
I struggled a little with getting DateTime format correct.

Below is a simple solution that should work for all (I hope).

Dim d As DateTime
d = Now
MsgBox("Time in MySQL DateTime format: " + d.ToString("yyyy-MM-dd HH:mm:ss"))

MySQL to MariaDB

 Here is a good description how to migrate to MariaDb MySQL to MariaDb Example of how to dump data from MySQL port=3307: mysqldump --user=ro...