[Mistery1]

Hi there,

I know MySql is already to take YYYY-MM-DD HH:MM:SS. Therefore I need to write code to change this format when saving into MySql database from my asp.net/vb application.

I have this code that does not work. It still saves as all zeros to the database. Does anyone have any clue hot to change this format to dd-mm-yyyy in the database?

Dim dateStr As String

dateStr = DateTime.Now.Month & "-"
dateStr &= DateTime.Now.Day & "-"
dateStr &= DateTime.Now.Year & " "
dateStr &= DateTime.Now.Hour & ":"
dateStr &= DateTime.Now.Minute & ":"
dateStr &= DateTime.Now.Second &

[slapshot_oi]

You're reinventing the wheel with your function. There are routines that .Net has in place that deal with date formats: Standard DateTime Format Strings. And here is a cheat sheet.

[gc69172]

Yes you can use the toshortdate format in C#/Vb to do so. See the available options in the date format then you can do it.