joebartels · September 11, 2018 23:45
diff --git a/medium.date_fields_vs_extract.create_table_cycling_entry.sql b/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
 );
	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
	);