Same table, meant to replace table name with X for simplicity
Sybrand Bakker wrote in message
<942175422.24470.0.pluto.d4ee154e_at_news.demon.nl>...
>What is the difference between the table or view x and the table or view
>media_nvod_dates?
>
>Regards,
>
>
>--
>Sybrand Bakker, Oracle DBA
>Douglas Whitacre <whitacre_at_imake.com> wrote in message
>news:lJZV3.1737$K5.261055_at_typhoon2.gnilink.net...
>> I have a record with Start Date & End Date. Record in the database are:
>>
>> contentId startDate endDate
>> --------- ------------------- -------------------
>> 73 03/01/2000 00:00:00 03/31/2000 23:59:59
>> 73 03/01/2000 00:00:00 03/31/2000 23:59:59
>>
>> when I run the following query it returns NO rows:
>>
>> SELECT content_id "contentId",
>> to_char(start_date, 'MM/DD/YYYY HH24:MI:SS') "startDate",
>> to_char(end_Date,'MM/DD/YYYY HH24:MI:SS') "endDate"
>> FROM x
>> WHERE (x_id = 3)
>> AND (start_date <= to_date('03/31/2000 23:59:59', 'MM/DD/YYYY
>> HH24:MI:SS'))
>> AND (end_date >= to_date('03/01/2000 00:00:00', 'MM/DD/YYYY
>HH24:MI:SS'))
>> ORDER BY content_id, start_date
>>
>>
>> However, when I run the following query it returns both rows (using
>> 12/31/1999 as end date comparison):
>>
>> SELECT content_id "contentId",
>> to_char(start_date, 'MM/DD/YYYY HH24:MI:SS') "startDate",
>> to_char(end_Date,'MM/DD/YYYY HH24:MI:SS') "endDate"
>> FROM media_nvod_dates
>> WHERE (nvod_id = 3)
>> AND (start_date <= to_date('03/31/2000 23:59:59', 'MM/DD/YYYY
>> HH24:MI:SS'))
>> AND (end_date >= to_date('12/31/1999 00:00:00', 'MM/DD/YYYY
>HH24:MI:SS'))
>> ORDER BY 2,3
>>
>> Anyone have similar problems?
>>
>>
>>
>
>
Received on Tue Nov 09 1999 - 14:32:32 CST
