Advertisement
Guest User

Untitled

a guest
Aug 27th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.24 KB | None | 0 0
  1. DECLARE @now datetime;
  2.  
  3. SET @now = GETDATE();
  4.  
  5. SELECT CONVERT(nvarchar(max), @now, 0) AS output, 0 AS style
  6. UNION
  7. SELECT CONVERT(nvarchar(max), @now, 1), 1
  8. UNION
  9. SELECT CONVERT(nvarchar(max), @now, 2), 2
  10. UNION
  11. SELECT CONVERT(nvarchar(max), @now, 3), 3
  12. UNION
  13. SELECT CONVERT(nvarchar(max), @now, 4), 4
  14. UNION
  15. SELECT CONVERT(nvarchar(max), @now, 5), 5
  16. UNION
  17. SELECT CONVERT(nvarchar(max), @now, 6), 6
  18. UNION
  19. SELECT CONVERT(nvarchar(max), @now, 7), 7
  20. UNION
  21. SELECT CONVERT(nvarchar(max), @now, 8), 8
  22. UNION
  23. SELECT CONVERT(nvarchar(max), @now, 9), 9
  24. UNION
  25. SELECT CONVERT(nvarchar(max), @now, 10), 10
  26. UNION
  27. SELECT CONVERT(nvarchar(max), @now, 11), 11
  28. UNION
  29. SELECT CONVERT(nvarchar(max), @now, 12), 12
  30. UNION
  31. SELECT CONVERT(nvarchar(max), @now, 13), 13
  32. UNION
  33. SELECT CONVERT(nvarchar(max), @now, 14), 14
  34. --15 to 19 not valid
  35. UNION
  36. SELECT CONVERT(nvarchar(max), @now, 20), 20
  37. UNION
  38. SELECT CONVERT(nvarchar(max), @now, 21), 21
  39. UNION
  40. SELECT CONVERT(nvarchar(max), @now, 22), 22
  41. UNION
  42. SELECT CONVERT(nvarchar(max), @now, 23), 23
  43. UNION
  44. SELECT CONVERT(nvarchar(max), @now, 24), 24
  45. UNION
  46. SELECT CONVERT(nvarchar(max), @now, 25), 25
  47. --26 not valid
  48. UNION
  49. SELECT CONVERT(nvarchar(max), @now, 100), 100
  50. UNION
  51. SELECT CONVERT(nvarchar(max), @now, 101), 101
  52. UNION
  53. SELECT CONVERT(nvarchar(max), @now, 102), 102
  54. UNION
  55. SELECT CONVERT(nvarchar(max), @now, 103), 103
  56. UNION
  57. SELECT CONVERT(nvarchar(max), @now, 104), 104
  58. UNION
  59. SELECT CONVERT(nvarchar(max), @now, 105), 105
  60. UNION
  61. SELECT CONVERT(nvarchar(max), @now, 106), 106
  62. UNION
  63. SELECT CONVERT(nvarchar(max), @now, 107), 107
  64. UNION
  65. SELECT CONVERT(nvarchar(max), @now, 108), 108
  66. UNION
  67. SELECT CONVERT(nvarchar(max), @now, 109), 109
  68. UNION
  69. SELECT CONVERT(nvarchar(max), @now, 110), 110
  70. UNION
  71. SELECT CONVERT(nvarchar(max), @now, 111), 111
  72. UNION
  73. SELECT CONVERT(nvarchar(max), @now, 112), 112
  74. UNION
  75. SELECT CONVERT(nvarchar(max), @now, 113), 113
  76. UNION
  77. SELECT CONVERT(nvarchar(max), @now, 114), 114
  78. UNION
  79. SELECT CONVERT(nvarchar(max), @now, 120), 120
  80. UNION
  81. SELECT CONVERT(nvarchar(max), @now, 121), 121
  82. --122 to 125 not valid
  83. UNION
  84. SELECT CONVERT(nvarchar(max), @now, 126), 126
  85. UNION
  86. SELECT CONVERT(nvarchar(max), @now, 127), 127
  87. --128, 129 not valid
  88. UNION
  89. SELECT CONVERT(nvarchar(max), @now, 130), 130
  90. UNION
  91. SELECT CONVERT(nvarchar(max), @now, 131), 131
  92. --132 not valid
  93. ORDER BY style;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement