| | |
Date and time Functions in MSSQL queryThere 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.
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.
We can format date and time to store them in MSSQL database. Before adding we can check the format also.
Getting different day parts like Year, Month, day etc from the MSSQL table
Updating DateTime filed in MSSQL table
How to get difference in days or months or year between two date field.
Various examples to work with data query in MSSQL database.
| |
| | |
|
|
|
|
|
