SQL query to get recently created users in OIM

Question

Is there a SQL query for users created in OIM. There are no dates provided while creating users in OIM, But we need to find the users on the basis of their creation date.

Answer 1

Select * from usr where to_date(usr_create)>to_date('01-Jun-2016', 'DD-MON-YYYY');