There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Software Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Software Development >
Oracle Does Not Select Based on Dates!!


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
Prashanti's Avatar
Computer Specs
Member with 60 posts.
 
Join Date: Apr 2006
Experience: Intermediate
10-Aug-2007, 04:43 AM #1
Oracle Does Not Select Based on Dates!!
This seems to be a day of problems.
I gave a simple Oracle select query

select * from readertable where STATUSDATE='17-MAR-07';

It didn't return any records eve though I know there is a record. The reason I know this, is because when I searched with another query on the same table

select * from readertable where READERNO=17;

it showed the STATUSDATE as '17-MAR-07'!!!

Here's another interesting quirk . When I run a date query on another table it shows the result!!!

What am I to make of all this ????? Where is the prob???

Pleeeeeeeeeeease Help!

Thanks.
Prashanti's Avatar
Computer Specs
Member with 60 posts.
 
Join Date: Apr 2006
Experience: Intermediate
13-Aug-2007, 06:32 AM #2
Solved with <=
I tried giving the query like

select * from <tablename> where STATUSDATE<='17-MAR-07'

and it worked ! It gave all the rows before 17-MAR-07 but at least it gave a result !
Don't ask me why , it just did .
Reply


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

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 On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 12:21 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.