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'
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' ********************* The way we do this redbrick is where time_stamp(datefield, timefield) between etc. If we get back to the original question of why you would separate date and time fields, it comes down to the requirements of your application, the data you are collecting, etc. The original question did not specify what field in what database, etc, ie, it was a general question. My original answer included another reason that had nothing to do with available functions and may have gotten lost in the shuffle. I will repeat it for emphasis. Depending on the nature of the data, you may know either the date or the time but not both. Separate fields allow you to store the part you have instead of leaving the entire field null. - 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)
