Softerra LDAP Administrator HelpShow AllHide All

CURRENT_DATE

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

Syntax

CURRENT_DATE

Examples

The following example searches for all users whose account expires in one month.

SELECT $accountExpires FROM ROOTDSE 
WHERE $accountExpires > CURRENT_DATE 
    AND $accountExpires < CURRENT_DATE + interval '1 month';