Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. トレジャーデータ上でカレンダーテーブルを作る
  2. ===
  3.  
  4. ```
  5. SELECT
  6. TD_TIME_FORMAT(TD_TIME_ADD(TD_SCHEDULED_TIME(), CONCAT('-',s.s,'d')), 'yyyy-MM-dd','JST') AS d
  7. FROM (
  8. SELECT
  9. GENERATE_SERIES(0, 40) AS s
  10. ) AS s
  11. ORDER BY d desc
  12. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement