Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- トレジャーデータ上でカレンダーテーブルを作る
- ===
- ```
- SELECT
- TD_TIME_FORMAT(TD_TIME_ADD(TD_SCHEDULED_TIME(), CONCAT('-',s.s,'d')), 'yyyy-MM-dd','JST') AS d
- FROM (
- SELECT
- GENERATE_SERIES(0, 40) AS s
- ) AS s
- ORDER BY d desc
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement