SQL Query

[Anon]

Hello all... I would appriciate an answer in SQL statement that I describe below.

I am trying to select rows from the table that along with other fields, have date and time fileds.
if I want to select a certain date and time for my starting point and till my ending point in same format, how would I go about doing it?

Shortly I want to select something like this

from 5/1/2001 12:07:33 PM till 5/7/2001 7:43:23 AM ( considering date time in 2 different fileds of database)

Thanks a lot.

[dstockto]

I cannot think of an easy way to do that right off, but perhaps you could just do the select on your two dates alone, and then in the script have it check each result if it falls on the beginning or end date to determine if it meets the time requirements.

ie,

SELECT * from table WHERE date>='$start_date' AND date <='$end_date'

Then when you loop through the results check the date and if the date is $start_date then make sure the time field is something after your requested time, and if the date is $end_date then make sure the time is some time before your request end time.

Dave

[Anon]

Hello All.

I am trying to select rows from the table that along with other fields, have date and time fileds.
if I want to select a certain date and time for my starting point and till my ending point in same format, how would I go about doing it?

Shortly I want to select something like this

from 5/1/2001 12:07:33 PM till 5/7/2001 7:43:23 AM ( considering date time in 2 different fileds of database)

Help will be greatly appriciated
Thanks a lot