Skip to content

Instantly share code, notes, and snippets.

@adamsafr

adamsafr/[MySQL] Generate date sequence

Created August 22, 2016 04:51
Show Gist options
  • Save adamsafr/eda07ae424f16b0f038e8419cb10e8a2 to your computer and use it in GitHub Desktop.
Save adamsafr/eda07ae424f16b0f038e8419cb10e8a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
[MySQL] Generate date sequence
SELECT DATE_ADD('2016-08-02', INTERVAL help_topic_id DAY) as mydate
FROM mysql.help_topic order by help_topic_id asc limit 14
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment