Date and time Functions in MSSQL query
MSSQL Date & Time function Examples 
Inserting present date and time in a field by default
How to format Date & Time variable to insert into MSSQL table
DatePart to get part of a date & time field of MSSQL record
Updating MSSQL date & time field
DateDiff: Getting the Difference in days, month and year between two date fields
Month: Month in numbers from DateTime field
Year: Year from DateTime field
Day: Day from DateTime field
Example of Date Query: Last n days record, todays records
destination source:https://www.plus2net.com/asp-tutorial/sql-dt.php
Date and time Functions in MSSQL query
There are various functions available in MSSQL database to handle date and time. We can perform date and time calculations through SQL and display the result. There are many date functions for data handling and we will discuss here with some examples. These functions can be combined with various other functions of ASP to develop powerful scripts.DateAdd: Adding data to DateTime field
We can add data to DateTime field of MSSQL database by using Query or by using default constraint to the table. We can add future date also.Date Format
We can format date and time to store them in MSSQL database. Before adding we can check the format also.Parts of the Date
Getting different day parts like Year, Month, day etc from the MSSQL tableUpdating Data
Updating DateTime filed in MSSQL tableDateDiff: Date Difference
How to get difference in days or months or year between two date field.Date Query Examples
Various examples to work with data query in MSSQL database. Inserting present date and time in a field by default How to format Date & Time variable to insert into MSSQL tableDatePart to get part of a date & time field of MSSQL recordUpdating MSSQL date & time fieldDateDiff: Getting the Difference in days, month and year between two date fieldsMonth: Month in numbers from DateTime fieldYear: Year from DateTime fieldDay: Day from DateTime fieldExample of Date Query: Last n days record, todays recordsRelated Article
destination source:https://www.plus2net.com/asp-tutorial/sql-dt.php