Current location: Hot Scripts Forums » Other Discussions » Database » Oracle Problem


Oracle Problem

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

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 ?
Closed Thread

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
php oracle problem umarrana Web Servers 2 03-28-08 07:26 AM
problem make connection with oracle elli_dian Everything Java 1 05-17-06 05:15 AM
PHP with Oracle Connection problem !!! please Help webFani PHP 0 11-08-04 12:30 AM
Selct problem in Oracle budik PHP 0 02-14-04 04:03 AM


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