How to convert date to Unix timestamp in PL SQL?

Question

Working with date/time

Good afternoon, there is a date in the format 05/30/16 00:00:00,0000. How can it be converted into an integer Unix timestamp, that is, so that the output is 1464566400.
And in such a way that if the date is earlier than 1970, then what should go into a negative value. That is, for signed int

Answer 1

to_timestamp('30.05.16 00:00:00,0000', 'DD.MM.YY HH:MI:SS,MS')

https://www.postgresql.org/docs/8.2/functions-form...