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






  1. SQL Server / T-SQL
  2. Date Timezone
  3. GetDate

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