The SQL DATEPART function returns the specified part of the input date. Description The SQL DATEPART function returns an integer value that

Read More
SQL DATEPART Function (Transact SQL)

The SQL GETDATE function returns the current timestamp of the database as a datetime value. Description The current timestamp derives from the

Read More
SQL GETDATE Function (Transact SQL)

Use SQL DATEADD to add days, weeks, months, or any timespan specified by datepart to a date to get another. The function

Read More
SQL DATEADD Function (Transact SQL)

The SQL DATEDIFF function calculates and returns the difference between two date values. The value returned is an integer. You can use

Read More
SQL DATEDIFF Function (Transact SQL)

When working with SQL dates, sometimes you need to calculate the end of the month.  Months are tricky!  Some are 28 days,

Read More
Calculate the Last Day of the Month using SQL