Skip to content

Instantly share code, notes, and snippets.

@moonhouse

moonhouse/sqlite-date-convert.sql

Created April 13, 2018 13:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save moonhouse/57ce79fefdc1ca7ce7c55e2bccd54dde to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save moonhouse/57ce79fefdc1ca7ce7c55e2bccd54dde to your computer and use it in GitHub Desktop.
Download ZIP
Convert date in RFC822 format to ISO-8601 format
Raw
sqlite-date-convert.sql
-- Convert date in format 31 Mar 2017 (DD mmm YYYY) to 2017-03-31 (YYYY-MM-DD)
select day, substr(day,8,4) || '-' || case when instr('JanFebMarAprMayJunJulAugSepOctNovDec',substr(day,4,3)) < 27 THEN '0' ELSE '' END || cast(instr('JanFebMarAprMayJunJulAugSepOctNovDec',substr(day,4,3))/3+1 as TEXT) || '-' ||substr(day,1,2) from dfix;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment