Dears
I have the following query
Code:
SELECT NAME, NAME_A, PASSWORD, ROUND((SYSDATE) - LAST_UPDATE_PASS_DATE), NVL(CHANGED_PASSWORD, 0), BRANCH_NO, STATUS, TO_CHAR(NVL(FROM_DATE, '02-21-2011'), 'DD/MM/YYYY'), TO_CHAR(NVL(TO_DATE, '02-21-2011'), 'DD/MM/YYYY')
FROM USERS WHERE LOWER(USERNAME) = LOWER('SA') AND
COMPANY_NO = '1' AND ((NVL(MENAPAY, 0) = 1
AND (USERS.BRANCH_NO = '1' OR '1' IN ( SELECT USER_BRANCH_CODE FROM USERS_BRANCHES WHERE COMPANY_NO = USERS.COMPANY_NO AND BRANCH_NO = USERS.BRANCH_NO AND LOWER(USERNAME) = LOWER(USERS.USERNAME) ))) OR (LOWER('SA') = 'SA'))
when I run on Oracle I have the below error
09:50:15 Error: ORA-01843: not a valid month
could any one help ?