Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @now datetime;
- SET @now = GETDATE();
- SELECT CONVERT(nvarchar(max), @now, 0) AS output, 0 AS style
- UNION
- SELECT CONVERT(nvarchar(max), @now, 1), 1
- UNION
- SELECT CONVERT(nvarchar(max), @now, 2), 2
- UNION
- SELECT CONVERT(nvarchar(max), @now, 3), 3
- UNION
- SELECT CONVERT(nvarchar(max), @now, 4), 4
- UNION
- SELECT CONVERT(nvarchar(max), @now, 5), 5
- UNION
- SELECT CONVERT(nvarchar(max), @now, 6), 6
- UNION
- SELECT CONVERT(nvarchar(max), @now, 7), 7
- UNION
- SELECT CONVERT(nvarchar(max), @now, 8), 8
- UNION
- SELECT CONVERT(nvarchar(max), @now, 9), 9
- UNION
- SELECT CONVERT(nvarchar(max), @now, 10), 10
- UNION
- SELECT CONVERT(nvarchar(max), @now, 11), 11
- UNION
- SELECT CONVERT(nvarchar(max), @now, 12), 12
- UNION
- SELECT CONVERT(nvarchar(max), @now, 13), 13
- UNION
- SELECT CONVERT(nvarchar(max), @now, 14), 14
- --15 to 19 not valid
- UNION
- SELECT CONVERT(nvarchar(max), @now, 20), 20
- UNION
- SELECT CONVERT(nvarchar(max), @now, 21), 21
- UNION
- SELECT CONVERT(nvarchar(max), @now, 22), 22
- UNION
- SELECT CONVERT(nvarchar(max), @now, 23), 23
- UNION
- SELECT CONVERT(nvarchar(max), @now, 24), 24
- UNION
- SELECT CONVERT(nvarchar(max), @now, 25), 25
- --26 not valid
- UNION
- SELECT CONVERT(nvarchar(max), @now, 100), 100
- UNION
- SELECT CONVERT(nvarchar(max), @now, 101), 101
- UNION
- SELECT CONVERT(nvarchar(max), @now, 102), 102
- UNION
- SELECT CONVERT(nvarchar(max), @now, 103), 103
- UNION
- SELECT CONVERT(nvarchar(max), @now, 104), 104
- UNION
- SELECT CONVERT(nvarchar(max), @now, 105), 105
- UNION
- SELECT CONVERT(nvarchar(max), @now, 106), 106
- UNION
- SELECT CONVERT(nvarchar(max), @now, 107), 107
- UNION
- SELECT CONVERT(nvarchar(max), @now, 108), 108
- UNION
- SELECT CONVERT(nvarchar(max), @now, 109), 109
- UNION
- SELECT CONVERT(nvarchar(max), @now, 110), 110
- UNION
- SELECT CONVERT(nvarchar(max), @now, 111), 111
- UNION
- SELECT CONVERT(nvarchar(max), @now, 112), 112
- UNION
- SELECT CONVERT(nvarchar(max), @now, 113), 113
- UNION
- SELECT CONVERT(nvarchar(max), @now, 114), 114
- UNION
- SELECT CONVERT(nvarchar(max), @now, 120), 120
- UNION
- SELECT CONVERT(nvarchar(max), @now, 121), 121
- --122 to 125 not valid
- UNION
- SELECT CONVERT(nvarchar(max), @now, 126), 126
- UNION
- SELECT CONVERT(nvarchar(max), @now, 127), 127
- --128, 129 not valid
- UNION
- SELECT CONVERT(nvarchar(max), @now, 130), 130
- UNION
- SELECT CONVERT(nvarchar(max), @now, 131), 131
- --132 not valid
- ORDER BY style;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement