Skip to content

Instantly share code, notes, and snippets.

@joebartels

joebartels/medium.date_fields_vs_extract.create_table_cycling_entry.sql

Created September 11, 2018 23:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joebartels/64cf92e18d4e73be70aacfb96502d50e to your computer and use it in GitHub Desktop.
Save joebartels/64cf92e18d4e73be70aacfb96502d50e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
medium.date_fields_vs_extract.create_table_cycling_entry.sql
create table cycling_entry (
id serial primary key,
date timestamptz,
day_of_week smallint default 0,
hour_of_day smallint default 0,
minute_of_hour smallint default 0,
km_cycled smallint
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment