Date Functions

SQL Server Date Functions

Data Types in SQL

• DATE - format YYYY-MM-DD
• YEAR - format YYYY or YY

SQL Server

• DATE - format YYYY-MM-DD
• SMALL
• TIMESTAMP - format: a unique number

Data Types.

Working with dates in SQL

For this we use this query:

1

SELECT * FROM Orders WHERE OrderDate=' '

Query Result:

1

SELECT * FROM Orders WHERE OrderDate=' '