I want to compare two date formats and return "false" when two formats are not equal.
For example, I get two dates, 24/10/2012 (DD/MM/YYYY) and 2016/11/05 (YYYY/MM/DD)... in this case some function should return false because date formats are not equal.
I want a function thats returns false when the second format to compare not equal the SQL format (YYYY-MM-DD).
You are asking a question (or two) which does not need to be answered.
Dates do not have a format Formats are how dates are displayed to humans. A date is simply a very large number like
636094492018399433L. It does not have a format.
I want a function thats returns false when the second format to compare not equal the SQL format (YYYY-MM-DD)
You really need not worry about the db format using the NET DB providers (e.g. OleDB, SQLite, SQL Server, MySQL). They all know how to properly store date data to a date column - its their job. If your columns are string, don't do that. If you want dates to act like dates, store them as dates.
Database docs bother to explain date formats for cases where you are entering data via a Shell interface from the keyboard, or perhaps importing data from a text/csv file. When using the NET DB Providers, the data format is an implementation detail.
Using dbCon As New MySQLConnection(mySQLConnStr) Using cmd As New MySqlCommand(SQL, dbCon) dbCon.Open() cmd.Parameters.Add("@p1", MySqlDbType.DateTime).Value = fromDate cmd.Parameters.Add("@p2", MySqlDbType.DateTime).Value = toDate cmd.ExecuteQuery End Using End Using
To Store just the date, most DBs have a separate
DbType.Date, but often you need to only pass the
cmd.Parameters.Add("@p2", MySqlDbType.Date).Value = toDate.Date
The NET DB Providers all Know Things, like how to take a NET Date and save it to the database they were built for, and do so in a format it can parse/read back from.