Home
SQL Server / T-SQL
Aggregate Functions
Analytical Functions
Constraints
Cursor
Data Set
Data Type
Database
Date Timezone
Index
Insert Delete Update
Math Functions
Select Query
Sequence
Store Procedure Function
String Functions
Subquery
System
Table
Table Joins
Transact SQL
Transaction
Trigger
View
XML
GetDate « Date Timezone « SQL Server / T-SQL
SQL Server / T-SQL
Date Timezone
GetDate
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
4.
Adding to a Date Using the Addition Operator