Adding to a Date Using the Addition Operator : GetDate « Date Timezone « SQL Server / T-SQL





Adding to a Date Using the Addition Operator

 

3>
4> SELECT
5>   GETDATE () + 1.5
6> GO

-----------------------
2007-10-23 13:16:54.380

(1 rows affected)

 










Related examples in the same category

1.GETDATE: Returns the current local system date and time
2.GETDATE(): Return the current date and time as a DateTime type
3.Update the record with the current data and time using the GETDATE() function