Rick Root wrote: > Curious that the entry makes NO mention of the dateConvert() function.
because that issue applies to *all* cf datetimes. and in any case, there's a tz bug in dateConvert(). i think peter f. blogged about it recently. > Of course, I understand it's meaning - that coldfusion still doesn't > know anything about timezones in datetime objects. Which is fine for my it's a bit more subtle, it only knows the server's TZ (it assumes all datetimes are in the server's tz). > purposes.. as long as the local SERVER time is converted to UTC time, > I've got something to work with. depending on the server's tz, it will be wrong twice a year. > Actually, UTC Strings are nicely sortable because they look like this: > > 2006-09-08T18:20:00Z perhaps, but the "etc." like date math, and more "etc."? > Now, the dates are stored in the database in UTC time and returned to one last time, depending on the server's tz that's an assumption on your part. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
