I've got a column of type
date with the following value format:
2018-08-03). I want to get the unix timestamp equivalent of the dates, but without the timezone.
F.e. the date
2018-08-03 should equal
1533254400 (as of calculated here).
to_timestamp(my_date_column, 'YYYY-MM-DD') but it returns error
function to_timestamp(date, unknown) does not exist. I've tried adding different variations of
::timestamp... at the end of the function call, but to no avail.
Currently I do the timestamp conversion in the application layer, but I'd like to dedicate that job to the database.