I migrate from SQL Server to PostgreSQL. How to translate the getutcdate function like:
Insert into mytable (mypk, toucheddate) values (99, getutcdate() )
(I'm not asking for an equivalent to MySQL, this is a different platform)
There are at least two ways to get the current time in UTC:
select now() at time zone 'utc';
select current_timestamp at time zone 'utc';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With