From d34d39ade76e6b67299d8d88a7e5a2278a793dc3 Mon Sep 17 00:00:00 2001 From: Adam Chainz Date: Mon, 1 Jun 2015 18:00:34 +0100 Subject: Fixed #24894 -- Added contrib.postgres.functions.TransactionNow --- docs/ref/models/database-functions.txt | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'docs/ref/models') diff --git a/docs/ref/models/database-functions.txt b/docs/ref/models/database-functions.txt index f1293ba741..336e4afc05 100644 --- a/docs/ref/models/database-functions.txt +++ b/docs/ref/models/database-functions.txt @@ -203,7 +203,8 @@ Now .. versionadded:: 1.9 -Returns the database server's current date and time when the query is executed. +Returns the database server's current date and time when the query is executed, +typically using the SQL ``CURRENT_TIMESTAMP``. Usage example:: @@ -211,6 +212,13 @@ Usage example:: >>> Article.objects.filter(published__lte=Now()) [] +.. admonition:: PostgreSQL considerations + + On PostgreSQL, the SQL ``CURRENT_TIMESTAMP`` returns the time that the + current transaction started. Therefore for cross-database compatibility, + ``Now()`` uses ``STATEMENT_TIMESTAMP`` instead. If you need the transaction + timestamp, use :class:`django.contrib.postgres.functions.TransactionNow`. + Substr ------ -- cgit v1.3