SyntaxFix
Write A Post
Hire A Developer
Questions
You could also do:
SELECT EMP_NAME, DEPT FROM EMPLOYEE WHERE TRUNC(TIME_CREATED) = DATE '2011-01-26'