Library Version 18.1.40

DB_ENV->set_tx_timestamp()
Prev | Chapter 12. The DB_TXN Handle | Next

## DB_ENV->set_tx_timestamp()

    #include <db.h>

    int
    DB_ENV->set_tx_timestamp(DB_ENV *dbenv, time_t *timestamp);

Recover to the time specified by timestamp rather than to the most current possible date.

Once a database environment has been upgraded to a new version of Berkeley DB involving a log format change (see Upgrading Berkeley DB installations), it is no longer possible to recover to a specific time before that upgrade.

The `DB_ENV->set_tx_timestamp()` method configures operations performed using the specified DB_ENV handle, not all operations performed on the underlying database environment.

The `DB_ENV->set_tx_timestamp()` method may not be called after the DB_ENV->open() method is called.

The `DB_ENV->set_tx_timestamp()` method returns a non-zero error value on failure and 0 on success.

### Parameters

#### timestamp

The timestamp parameter references the memory location where the recovery timestamp is located.

The timestamp parameter should be the number of seconds since 0 hours, 0 minutes, 0 seconds, January 1, 1970, Coordinated Universal Time; that is, the Epoch.

### Errors

The `DB_ENV->set_tx_timestamp()` method may fail and return one of the following non-zero errors:

#### EINVAL

If it is not possible to recover to the specified time using the log files currently present in the environment; or if an invalid flag value or parameter was specified.

### Class

DB_ENV, DB_TXN

### See Also

Transaction Subsystem and Related Methods

Prev | Up | Next
DB_ENV->set_tx_max() | Home | DB_ENV->txn_recover()