Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE DATES
- (
- Column_for_dates DATETIME NOT NULL
- )
- INSERT INTO DATES(Column_for_dates) VALUES ('21-10-2020 10:30' )
- SELECT * FROM DATES
- SELECT GETDATE()
- INSERT INTO DATES(Column_for_dates) VALUES ('2020-10-22 10:30')
- INSERT INTO DATES(Column_for_dates) VALUES (CONVERT (DATETIME, '21-10-2020 10:30', 105))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement