How to compare two dates FORMATS for saving to DB

Question

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).

Answer 1

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

• specify the DbType as DateTime
• pass it Date data.

To Store just the date, most DBs have a separate DbType.Date, but often you need to only pass the .Date portion:

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.