Advertisement
Guest User

Untitled

a guest
Nov 20th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. drop table if exists #tbl
  2. create table #tbl(id int, dt datetime )
  3.  
  4. insert into #tbl
  5. values(1, '2019-11-20 15:30:00.000'),
  6. (2, '2019-11-20 15:32:00.000'),
  7. (3, '2019-11-20 15:34:00.000'),
  8. (4, '2019-11-20 15:45:00.000'),
  9. (5, '2019-11-20 15:48:00.000');
  10.  
  11. select id, dt from #tbl
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement