X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/00c2e9b28c1228b2ba327223d5576d44e4fdae4d..HEAD:/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 ef68b0d09a..2d58e3c389 100644 --- a/services/api/lib/db_current_time.rb +++ b/services/api/lib/db_current_time.rb @@ -1,7 +1,15 @@ +# Copyright (C) The Arvados Authors. All rights reserved. +# +# SPDX-License-Identifier: AGPL-3.0 + module DbCurrentTime - CURRENT_TIME_SQL = "SELECT CURRENT_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