Barney Boisvert wrote: > > where datefield between '2002:07:09 00:00:00' and '2003:07:09 00:00:01' > > The delimiter used is inconsequential, you can use pretty much any > punctuation character, and you can use several in a single value (2003:07/09 > 00+00-00). I use colons throughout for consistency, but that's personal > preference.
You might as well use a "-" between the parts of the date and a ":" between the parts of the time. It is something that CF understands, and it is consistent with ISO 8601 so it gives you a high chance of portability to other databases. I would not use a "+" or a "-" in the time part ever. Way to much risk of confusion when you have a database that supports time zones. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
