using generate_series to create bunch of random dates throughout "a year"

medium_date_fields_vs_extract_generate_series_random_dates.sql

with days as (
  select *
    from generate_series(
           '1988-01-01T00:00:00'::timestamptz,
           '2019-01-01T00:00:00'::timestamptz - '1 day'::interval,
           '1 day'::interval
         ) as date
)

-- uncomment to insert into the table
-- insert into cycling_entry (date, km_cycled)
select date + ('1 day'::interval * int_between(-7, 7))
            + ('1 hour'::interval * int_between(0, 24)) 
            + ('1 minute'::interval * int_between(0, 60)) as date,
       int_between(0, 100) as km_cycled
       
  from days;