#1 (permalink)  
Old 02-21-11, 02:02 AM
MZOWIS MZOWIS is offline
Newbie Coder
 
Join Date: Feb 2011
Location: Jordan
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Oracle

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 ?

Last edited by MZOWIS; 02-21-11 at 02:04 AM.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle tools. JeanPierre Website Reviews 0 08-18-05 04:27 AM
Selct problem in Oracle budik PHP 0 02-14-04 04:03 AM


All times are GMT -5. The time now is 09:58 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.