create table PASS_EXPIRATION_NOTIFY_ENTITY ( ID CHARACTER VARYING(36) not null, USER_ID CHARACTER VARYING(255), REALM_ID CHARACTER VARYING(255), EXPIRATION_DATE TIMESTAMP, NOTIFY_SCHEDULED_DATE TIMESTAMP, constraint PASS_EXPIRATION_NOTIFY_ENTITY_PK primary key (ID) ); select * from PASS_EXPIRATION_NOTIFY_ENTITY where NOTIFY_SCHEDULED_DATE > now()