Skip to content

Instantly share code, notes, and snippets.

@matallo
Created April 12, 2016 20:33
Show Gist options
  • Save matallo/106de268b7eb4266f96991ce26938367 to your computer and use it in GitHub Desktop.
Save matallo/106de268b7eb4266f96991ce26938367 to your computer and use it in GitHub Desktop.
SELECT *, to_char(timestamp, 'Day') as weekday, to_char(timestamp, 'HH24') as dayhour FROM matallo.feds1_copy_1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment