Softerra LDAP Administrator HelpShow AllHide All

CURRENT_TIMESTAMP

The function without any parameters. Returns the current date and time in the Timestamp date-time format.

Syntax

CURRENT_TIMESTAMP

Examples

The following example searches for all users whose accounts have already expired.

SELECT * FROM ROOTDSE
WHERE $objectCategory='Person' AND $objectClass='user'
    AND $accountExpires<CURRENT_TIMESTAMP AND $accountExpires>0;