inclusive date query

#1

Hve tble with date field.

the query prompts the user for the dates ( inclusive):
query is
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold <= '15-Feb-2004'

The query returns data from the 12, 13, and 14. but not from the 15th.

What is the syntax for the query to have data from the 15th included.
TIA

#2

Hello Bob,

Can you check if you have data from the 15th?

Try to use "select name, datesold from table where datesold =
'15-Feb-2004' to check.

Regards,

Ron
DBA Infopower
http://www.dbainfopower.com
Standard disclaimer:
http://www.dbainfopower.com/dbaip_ad...isclaimer.html

"Bob" <bob_NOSPAM_ (AT) e-wpm (DOT) com> wrote

Quote:

Hve tble with date field.

the query prompts the user for the dates ( inclusive):
query is
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold <= '15-Feb-2004'

The query returns data from the 12, 13, and 14. but not from the 15th.

What is the syntax for the query to have data from the 15th included.
TIA

#3

Bob wrote:

Quote:

Hve tble with date field.

the query prompts the user for the dates ( inclusive):
query is
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold <= '15-Feb-2004'

The query returns data from the 12, 13, and 14. but not from the 15th.

What is the syntax for the query to have data from the 15th included.
TIA

if datesold has a time, then it will only work on the 15th for exactly
midnight (00:00).

Try using TRUNC(datesold) to strip any times.

Steve

#4

Hello!
Try this:
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold < '16-Feb-2004'

Best regards,
Yaroslav.

"Bob" <bob_NOSPAM_ (AT) e-wpm (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:403152c2 (AT) news (DOT) splitrock.net...

Quote:

Hve tble with date field.

the query prompts the user for the dates ( inclusive):
query is
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold <= '15-Feb-2004'

The query returns data from the 12, 13, and 14. but not from the 15th.

What is the syntax for the query to have data from the 15th included.
TIA

#5

Wouldn't it be easier to use BETWEEN? BETWEEN is inclusive.

"select name, datesold from table where datesold between '12-Feb-2004'
and '15-Feb-2004'

On Tue, 17 Feb 2004 19:24:09 +0300, "Yaroslav Perventsev"
<p_yaroslav (AT) cnt (DOT) ru> wrote:

Quote:

Hello!
Try this:
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold < '16-Feb-2004'

Best regards,
Yaroslav.

"Bob" <bob_NOSPAM_ (AT) e-wpm (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:403152c2 (AT) news (DOT) splitrock.net...
Hve tble with date field.

the query prompts the user for the dates ( inclusive):
query is
select name, datesold from table where datesold >= '12-Feb-2004' and
datesold <= '15-Feb-2004'

The query returns data from the 12, 13, and 14. but not from the 15th.

What is the syntax for the query to have data from the 15th included.
TIA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

inclusive date query

comp.database.oracle comp.database.oracle

inclusive date query - 02-16-2004 , 04:56 PM

Re: inclusive date query - 02-16-2004 , 06:17 PM

Re: inclusive date query - 02-16-2004 , 07:39 PM

Re: inclusive date query - 02-17-2004 , 10:24 AM

Re: inclusive date query - 02-19-2004 , 08:37 AM