Softerra LDAP Administrator Help | Show AllHide All |
The function without any parameters. Returns the current date in the GeneralizedTime date-time format.
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';