I have the following table:
id time_start area 1 2019-09-01T10:12:32Z london 2 2019-08-29T10:13:32Z chicago 3 2019-07-31T10:14:32Z paris 4 2019-09-28T10:17:32Z madrid 5 2019-07-04T10:18:32Z spain
I would like to add a new column called correct_date which is just the time_start column:
the new column should be added to the end and look like this:
date_start 2019-09-01 2019-08-29 2019-07-31 2019-09-28 2019-07-04
however I am filtering the data before hand based on a where statement and am a bit stuck on how to alter the table after the where condition has been satisified - or which order to do the process in? I know I will have to use timestamp::date to attain the date.
my current query is
select * from my_table where area in ('london','chicago','paris')
how can I add an alter table statement to the above code so that it will add a new column based on the dates of the time_start column - would I do the alter statement at the beginning?
Couldn't find a clear answer online using postgresql!