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:
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
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!