Sql, Postgresql, Programming, Postgres, Data Science.
penguin_presents_2022 ADD COLUMN birth_date TEXT; Now we’ll populate it with random dates formatted as text: UPDATE penguin_presents_2022 SET birth_date = to_date( ('2000-01-01'::timestamp + random() * ('2022-12-31'::timestamp - '2000-01-01'::timestamp))::text, 'YYYY-MM-DD')::text Giving us a text