X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/0eb72b526bf8bbb011551ecf019f604e17a534f1..c3872e7a1c817cd39b702f694f70d34f28f7f472:/services/api/lib/db_current_time.rb diff --git a/services/api/lib/db_current_time.rb b/services/api/lib/db_current_time.rb index fdb6641521..2d58e3c389 100644 --- a/services/api/lib/db_current_time.rb +++ b/services/api/lib/db_current_time.rb @@ -3,9 +3,13 @@ # SPDX-License-Identifier: AGPL-3.0 module DbCurrentTime - CURRENT_TIME_SQL = "SELECT clock_timestamp()" + CURRENT_TIME_SQL = "SELECT clock_timestamp() AT TIME ZONE 'UTC'" def db_current_time - Time.parse(ActiveRecord::Base.connection.select_value(CURRENT_TIME_SQL)).to_time + ActiveRecord::Base.connection.select_value(CURRENT_TIME_SQL) + end + + def db_transaction_time + ActiveRecord::Base.connection.select_value("SELECT current_timestamp AT TIME ZONE 'UTC'") end end