SQL PHP HTML ASP JavaScript articles and free scripts to download
 

Date and time Functions in MSSQL query

There are various functions available in MSSQL database to handle date and time. We can do 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 and we can develop powerful scripts.
Further readings
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
 
Scripts
PHP
JavaScript
All ASP Tutorials
Popular Tutorials
Managing two drop downs
ASP Tutorials
Date and time
Declaring array
Form in ASP
Server.MapPath
Date Time & MSSQL
Select Query
File System Object
Subscribe
Submit your email address and receive article and product notifications. Your email is safe with us.