Home » SQL & PL/SQL » SQL & PL/SQL » query problem
query problem [message #241354] Tue, 29 May 2007 06:12 Go to next message
subhajit
Messages: 14
Registered: December 2006
Junior Member
Hello all,

I am using oracle 9i and vb6. From my program i run one query,

Select B from
A
Where ADATE
Between
to_date('09/10/2004 1:0:0 PM','mm/dd/yyyy hh:mi:ss AM')
and
to_date('09/11/2004 4:45:29 PM','mm/dd/yyyy hh:mi:ss AM')


then i take each B from that query and send it to a oracle procedure."A" table is huge. Is there any chance that this query
miss any or multiple row/rows? plzz help me.
Re: query problem [message #241356 is a reply to message #241354] Tue, 29 May 2007 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is any chance that the query misses any row.

Regards
Michel
Re: query problem [message #241382 is a reply to message #241356] Tue, 29 May 2007 07:26 Go to previous messageGo to next message
subhajit
Messages: 14
Registered: December 2006
Junior Member
I have another problem... I wrote one procedure...in that one select query I wrote...

SELECT MAX(BDATE) BDATE
INTO PUST1
FROM A
WHERE DNUMBER = DNO
GROUP BY DNUMBER;
DNO is CHAR type "In parameter"...and PUST1 is Date type out parameter.....In table A BDATE is date type table......Is this query returns Date with time or only Date?
Re: query problem [message #241383 is a reply to message #241382] Tue, 29 May 2007 07:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All Oracle dates also contain time.

Regards
Michel
Re: query problem [message #241395 is a reply to message #241383] Tue, 29 May 2007 08:05 Go to previous messageGo to next message
subhajit
Messages: 14
Registered: December 2006
Junior Member
but when i run this query in sqlplusw then its returns only date...
Re: query problem [message #241421 is a reply to message #241395] Tue, 29 May 2007 09:31 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because your default display format only contains date.
Use TO_CHAR to display your date and you also see the time.

Regards
Michel
Previous Topic: I need a query
Next Topic: Date Range Partitions
Goto Forum:
  


Current Time: Wed Dec 07 22:12:12 CST 2016

Total time taken to generate the page: 0.06159 seconds