Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is included.
- CREATE TABLE DateTest (id INT, order_date DATETIMEOFFSET NOT NULL DEFAULT SYSDATETIMEOFFSET())
- INSERT INTO DateTest (id) VALUES (1)
- SELECT * FROM DateTest
- DATEADD(hh, 1, order_date)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement