GETDATE: Returns the current local system date and time : GetDate « Date Timezone « SQL Server / T-SQL






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

GETDATE: Returns the current local system date and time


2> -- GETDATE: Returns the current local system date and time.
3>
4> SELECT GETDATE()
5> GO

-----------------------
2006-10-12 07:15:07.780

(1 rows affected)








Related examples in the same category

1.GETDATE(): Return the current date and time as a DateTime type
2.Update the record with the current data and time using the GETDATE() function
3.Adding to a Date Using the Addition Operator