---
title: "PostgreSQL specific database functions"
version: 1.9
locale: id
source: https://docs.djangoproject.com/id/1.9/ref/contrib/postgres/functions/
canonical: https://djangodocs.dev/id/1.9/ref/contrib/postgres/functions/
---
# PostgreSQL specific database functions

All of these functions are available from the
`django.contrib.postgres.functions` module.

## `TransactionNow`

#### `class TransactionNow`

> **New in Django 1.9**

Returns the date and time on the database server that the current transaction
started. If you are not in a transaction it will return the date and time of
the current statement. This is a complement to
[`django.db.models.functions.Now`](/id/1.9/ref/models/database-functions/#django.db.models.functions.Now), which returns the date and time of the
current statement.

Note that only the outermost call to [`atomic()`](/id/1.9/topics/db/transactions/#django.db.transaction.atomic)
sets up a transaction and thus sets the time that `TransactionNow()` will
return; nested calls create savepoints which do not affect the transaction
time.

Contoh penggunaan:

```
>>> from django.contrib.postgres.functions import TransactionNow
>>> Article.objects.filter(published__lte=TransactionNow())
[<Article: How to Django>]
```