API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
227
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.86 KB | None | 0 0
raw download clone embed print report
  1. select distinct
  2. substr(BOCRTNTIME,1,8),
  3. substr(BOCRTNTIME,9,2)
  4. from VIEW_BASE_MARIX_T
  5. order by substr(BOCRTNTIME,9,2);
  6.  
  7. "SUBSTR(BOCRTNTIME,1,8)" "SUBSTR(BOCRTNTIME,9,2)"
  8. "2015-07-" "01"
  9. "2016-02-" "01"
  10. "2015-04-" "01"
  11. "2015-06-" "01"
  12. "2015-02-" "01"
  13. "2016-12-" "01"
  14. "1970-01-" "01"
  15. "2015-09-" "01"
  16. "2015-11-" "01"
  17. "2015-01-" "01"
  18. "2015-12-" "01"
  19. "2015-10-" "01"
  20. "2015-08-" "01"
  21. "2015-05-" "01"
  22. "2015-02-" "02"
  23. "2015-09-" "02"
  24. "2015-07-" "02"
  25. "2016-02-" "02"
  26. "2015-05-" "02"
  27. "2015-04-" "02"
  28. "2015-10-" "02"
  29. "2015-12-" "02"
  30. "2015-08-" "02"
  31. "2015-03-" "02"
  32. "2015-11-" "02"
  33. "2015-06-" "02"
  34. "2016-02-" "03"
  35. "2016-01-" "03"
  36. "2015-07-" "03"
  37. "2015-02-" "03"
  38. "2015-12-" "03"
  39. "2015-09-" "03"
  40. "2015-08-" "03"
  41. "2015-10-" "03"
  42. "2015-03-" "03"
  43. "2015-06-" "03"
  44. "2015-05-" "03"
  45. "2015-11-" "03"
  46. "2015-04-" "03"
  47. "2015-06-" "04"
  48. "2015-07-" "04"
  49. "2015-02-" "04"
  50. "2015-03-" "04"
  51. "2015-04-" "04"
  52. "2016-02-" "04"
  53. "2015-05-" "04"
  54. "2015-09-" "04"
  55. "2015-08-" "04"
  56. "2015-10-" "04"
  57. "2016-01-" "04"
  58. "2015-12-" "04"
  59. "2015-11-" "04"
  60. "2016-01-" "05"
  61. "2015-06-" "05"
  62. "2015-02-" "05"
  63. "2015-10-" "05"
  64. "2015-11-" "05"
  65. "2015-07-" "05"
  66. "2016-02-" "05"
  67. "2015-08-" "05"
  68. "2015-12-" "05"
  69. "2015-03-" "05"
  70. "2015-05-" "05"
  71. "2015-04-" "05"
  72. "2015-09-" "05"
  73. "2015-12-" "06"
  74. "2016-02-" "06"
  75. "2015-05-" "06"
  76. "2015-06-" "06"
  77. "2015-04-" "06"
  78. "2015-08-" "06"
  79. "2016-01-" "06"
  80. "2015-11-" "06"
  81. "2015-03-" "06"
  82. "2015-09-" "06"
  83. "2015-07-" "06"
  84. "2015-10-" "06"
  85. "2015-02-" "06"
  86. "2015-06-" "07"
  87. "2015-11-" "07"
  88. "2015-05-" "07"
  89. "2015-07-" "07"
  90. "2015-03-" "07"
  91. "2015-04-" "07"
  92. "2015-10-" "07"
  93. "2015-02-" "07"
  94. "2015-12-" "07"
  95. "2015-09-" "07"
  96. "2016-02-" "07"
  97. "2016-01-" "07"
  98. "2015-08-" "07"
  99. "2015-05-" "08"
  100. "2015-12-" "08"
  101. "2015-08-" "08"
  102. "2015-11-" "08"
  103. "2015-04-" "08"
  104. "2015-06-" "08"
  105. "2015-09-" "08"
  106. "2016-02-" "08"
  107. "2016-01-" "08"
  108. "2015-10-" "08"
  109. "2015-07-" "08"
  110. "2015-11-" "09"
  111. "2015-09-" "09"
  112. "2015-05-" "09"
  113. "2015-04-" "09"
  114. "2015-08-" "09"
  115. "2015-07-" "09"
  116. "2016-01-" "09"
  117. "2015-12-" "09"
  118. "2015-06-" "09"
  119. "2015-10-" "09"
  120. "2015-03-" "09"
  121. "2015-02-" "09"
  122. "2015-08-" "10"
  123. "2015-05-" "10"
  124. "2015-04-" "10"
  125. "2015-10-" "10"
  126. "2015-07-" "10"
  127. "2015-06-" "10"
  128. "2016-01-" "10"
  129. "2015-12-" "10"
  130. "2015-03-" "10"
  131. "2015-09-" "10"
  132. "2015-02-" "10"
  133. "2016-02-" "10"
  134. "2015-11-" "10"
  135. "2015-04-" "11"
  136. "2016-01-" "11"
  137. "2015-10-" "11"
  138. "2015-05-" "11"
  139. "2015-12-" "11"
  140. "2015-02-" "11"
  141. "2015-11-" "11"
  142. "2015-09-" "11"
  143. "2015-06-" "11"
  144. "2015-08-" "11"
  145. "2016-02-" "11"
  146. "2015-07-" "11"
  147. "2015-03-" "11"
  148. "2015-06-" "12"
  149. "2015-10-" "12"
  150. "2015-08-" "12"
  151. "2016-02-" "12"
  152. "2015-11-" "12"
  153. "2015-07-" "12"
  154. "2015-02-" "12"
  155. "2015-05-" "12"
  156. "2015-01-" "12"
  157. "2016-01-" "12"
  158. "2015-09-" "12"
  159. "2015-12-" "12"
  160. "2015-04-" "12"
  161. "2015-03-" "12"
  162. "2015-07-" "13"
  163. "2015-01-" "13"
  164. "2015-10-" "13"
  165. "2016-01-" "13"
  166. "2015-12-" "13"
  167. "2015-03-" "13"
  168. "2015-06-" "13"
  169. "2015-08-" "13"
  170. "2015-04-" "13"
  171. "2015-09-" "13"
  172. "2015-02-" "13"
  173. "2015-05-" "13"
  174. "2015-11-" "13"
  175. "2015-04-" "14"
  176. "2015-10-" "14"
  177. "2015-01-" "14"
  178. "2015-07-" "14"
  179. "2015-08-" "14"
  180. "2015-09-" "14"
  181. "2015-12-" "14"
  182. "2016-01-" "14"
  183. "2015-06-" "14"
  184. "2015-02-" "14"
  185. "2015-11-" "14"
  186. "2015-03-" "14"
  187. "2015-05-" "14"
  188. "2015-07-" "15"
  189. "2016-01-" "15"
  190. "2015-01-" "15"
  191. "2015-08-" "15"
  192. "2015-09-" "15"
  193. "2015-12-" "15"
  194. "2015-03-" "15"
  195. "2015-06-" "15"
  196. "2015-02-" "15"
  197. "2015-05-" "15"
  198. "2015-04-" "15"
  199. "2015-10-" "15"
  200. "2015-11-" "15"
  201. "2015-10-" "16"
  202. "2015-09-" "16"
  203. "2015-08-" "16"
  204. "2015-06-" "16"
  205. "2015-07-" "16"
  206. "2015-03-" "16"
  207. "2015-04-" "16"
  208. "2016-01-" "16"
  209. "2015-01-" "16"
  210. "2015-11-" "16"
  211. "2015-12-" "16"
  212. "2015-02-" "16"
  213. "2015-09-" "17"
  214. "2015-08-" "17"
  215. "2015-02-" "17"
  216. "2015-03-" "17"
  217. "2015-07-" "17"
  218. "2016-01-" "17"
  219. "2015-06-" "17"
  220. "2015-04-" "17"
  221. "2015-12-" "17"
  222. "2015-05-" "17"
  223. "2015-10-" "17"
  224. "2015-11-" "17"
  225. "2015-02-" "18"
  226. "2016-01-" "18"
  227. "2015-03-" "18"
  228. "2015-07-" "18"
  229. "2015-12-" "18"
  230. "2015-08-" "18"
  231. "2015-04-" "18"
  232. "2015-05-" "18"
  233. "2015-06-" "18"
  234. "2015-09-" "18"
  235. "2015-10-" "18"
  236. "2015-11-" "18"
  237. "2015-08-" "19"
  238. "2015-06-" "19"
  239. "2015-07-" "19"
  240. "2015-11-" "19"
  241. "2015-01-" "19"
  242. "2016-01-" "19"
  243. "2015-05-" "19"
  244. "2015-09-" "19"
  245. "2015-12-" "19"
  246. "2015-03-" "19"
  247. "2015-04-" "19"
  248. "2015-02-" "19"
  249. "2015-10-" "19"
  250. "2015-04-" "20"
  251. "2015-10-" "20"
  252. "2016-01-" "20"
  253. "2015-05-" "20"
  254. "2015-08-" "20"
  255. "2015-01-" "20"
  256. "2015-09-" "20"
  257. "2015-12-" "20"
  258. "2015-11-" "20"
  259. "2015-02-" "20"
  260. "2015-07-" "20"
  261. "2015-06-" "20"
  262. "2015-03-" "20"
  263. "2015-01-" "21"
  264. "2015-06-" "21"
  265. "2015-04-" "21"
  266. "2016-01-" "21"
  267. "2015-07-" "21"
  268. "2015-11-" "21"
  269. "2015-05-" "21"
  270. "2015-02-" "21"
  271. "2015-09-" "21"
  272. "2015-10-" "21"
  273. "2015-12-" "21"
  274. "2015-03-" "21"
  275. "2015-08-" "21"
  276. "2015-06-" "22"
  277. "2015-12-" "22"
  278. "2016-01-" "22"
  279. "2015-10-" "22"
  280. "2015-01-" "22"
  281. "2015-07-" "22"
  282. "2015-03-" "22"
  283. "2015-11-" "22"
  284. "2015-08-" "22"
  285. "2015-04-" "22"
  286. "2015-05-" "22"
  287. "2015-02-" "22"
  288. "2015-09-" "22"
  289. "2015-10-" "23"
  290. "2015-06-" "23"
  291. "2015-02-" "23"
  292. "2015-04-" "23"
  293. "2015-09-" "23"
  294. "2015-05-" "23"
  295. "2015-12-" "23"
  296. "2015-07-" "23"
  297. "2015-08-" "23"
  298. "2016-01-" "23"
  299. "2015-01-" "23"
  300. "2015-11-" "23"
  301. "2015-03-" "23"
  302. "2015-04-" "24"
  303. "2015-09-" "24"
  304. "2015-07-" "24"
  305. "2015-02-" "24"
  306. "2015-12-" "24"
  307. "2015-11-" "24"
  308. "2015-05-" "24"
  309. "2015-10-" "24"
  310. "2016-01-" "24"
  311. "2015-01-" "24"
  312. "2015-08-" "24"
  313. "2015-03-" "24"
  314. "2015-06-" "24"
  315. "2015-08-" "25"
  316. "2016-01-" "25"
  317. "2015-07-" "25"
  318. "2015-11-" "25"
  319. "2015-04-" "25"
  320. "2015-03-" "25"
  321. "2015-12-" "25"
  322. "2015-02-" "25"
  323. "2015-05-" "25"
  324. "2015-06-" "25"
  325. "2015-09-" "25"
  326. "2015-10-" "25"
  327. "2015-10-" "26"
  328. "2015-05-" "26"
  329. "2015-06-" "26"
  330. "2015-12-" "26"
  331. "2015-11-" "26"
  332. "2016-01-" "26"
  333. "2015-03-" "26"
  334. "2015-09-" "26"
  335. "2015-08-" "26"
  336. "2015-01-" "26"
  337. "2015-02-" "26"
  338. "2015-07-" "26"
  339. "2015-04-" "26"
  340. "2015-07-" "27"
  341. "2015-10-" "27"
  342. "2016-01-" "27"
  343. "2015-09-" "27"
  344. "2015-03-" "27"
  345. "2015-01-" "27"
  346. "2015-11-" "27"
  347. "2015-08-" "27"
  348. "2015-04-" "27"
  349. "2015-02-" "27"
  350. "2015-05-" "27"
  351. "2015-06-" "27"
  352. "2015-12-" "27"
  353. "2015-05-" "28"
  354. "2015-08-" "28"
  355. "2015-04-" "28"
  356. "2015-06-" "28"
  357. "2015-09-" "28"
  358. "2015-03-" "28"
  359. "2015-12-" "28"
  360. "2016-01-" "28"
  361. "2015-11-" "28"
  362. "2015-02-" "28"
  363. "2015-01-" "28"
  364. "2015-07-" "28"
  365. "2015-10-" "28"
  366. "2015-09-" "29"
  367. "2016-01-" "29"
  368. "2015-11-" "29"
  369. "2015-05-" "29"
  370. "2015-06-" "29"
  371. "2015-08-" "29"
  372. "2015-01-" "29"
  373. "2015-10-" "29"
  374. "2015-12-" "29"
  375. "2015-07-" "29"
  376. "2015-03-" "29"
  377. "2015-04-" "29"
  378. "2015-01-" "30"
  379. "2015-12-" "30"
  380. "2015-07-" "30"
  381. "2015-09-" "30"
  382. "2015-04-" "30"
  383. "2015-05-" "30"
  384. "2014-12-" "30"
  385. "2015-08-" "30"
  386. "2016-01-" "30"
  387. "2015-06-" "30"
  388. "2015-11-" "30"
  389. "2015-03-" "30"
  390. "2015-10-" "30"
  391. "2015-08-" "31"
  392. "2015-03-" "31"
  393. "2015-10-" "31"
  394. "2015-12-" "31"
  395. "2015-05-" "31"
  396. "2015-01-" "31"
  397. "2015-07-" "31"
  398. "2016-01-" "31"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!