Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop table if exists #tbl
- create table #tbl(id int, dt datetime )
- insert into #tbl
- values(1, '2019-11-20 15:30:00.000'),
- (2, '2019-11-20 15:32:00.000'),
- (3, '2019-11-20 15:34:00.000'),
- (4, '2019-11-20 15:45:00.000'),
- (5, '2019-11-20 15:48:00.000');
- select id, dt from #tbl
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement