GETDATE(): Return the current date and time as a DateTime type : GetDate « Date Timezone « SQL Server / T-SQL






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

GETDATE(): Return the current date and time as a DateTime type

7>
8> SELECT GETDATE()
9> GO

-----------------------
2006-10-12 19:50:21.607

(1 rows affected)








Related examples in the same category

1.GETDATE: Returns the current local system date and time
2.Update the record with the current data and time using the GETDATE() function
3.Adding to a Date Using the Addition Operator