SQL Working With Dates

The most difficult part when working with dates in databases, is to be sure that the format of the date you are trying to insert/select, matches the format of the date column in the database.

Different SQL databases have various data types to store date and time values.

has the following date data types:

• format: HH:MI:SS

• format YYYY or YY SQL Server has the following date data types:

• format: HH:MI:SS

• format: a unique number

The date data type are defined for a column upon creation of a new table in your database.