But when you need to output records that were changed between 17-01-02 8:00 am. and 23-01-02 8:00 pm. it is easer to say: where datetime between '17-01-02 8:00' and '23-01-02 20:00'
than: ?.. Is that possible to do the same thing having datetime values separated? Obviously query: where DATEtime between '02-01-2002' and '02-05-2002' AND dateTIME between '08:00' and '20:00' will not return the same results. You probably would have to say something like: select (DATEtime dateTIME) as DATETIME_Joint where DATETIME_Joint between '17-01-02 8:00' and '23-01-02 20:00' I didn't tested this so I am not sure, or create two queries. Dimitri *************** Good point Dan, but computed values apply here to, don't they? Couldn't you do: where date(datetime) between '02-01-2002' and '02-05-2002' instead of: where datetime between '02-01-2002 00:00' and '02-05-2002 23:59' *************** Of course you can do that. It is just easier to not have to. - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Dimitri Abramov <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
