Looks like there are a few functions that do that: http://tinyurl.com/lo7fv
http://www.cflib.org/udf.cfm?ID=237 <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 2:47 PM To: CF-Talk Subject: Storing dates - displaying dates I'd like to store and display dates in CFMBB in a manner more independent of the server's date and time. Currently, all dates are inserted using the coldfusion Now() function (with cfqueryparam) so whatever timezone the server is located in is the date for the posting. There are a couple things I'd like to be able to do: #1 - store the data in GMT - which I think is without any daylight savings time modifications, right? #2 - Display the dates/times according to a configured timezone setting for the whole message board OR a configured time zone setting for a specific logged in user - taking daylight savings into consideration. It's easy enough to handle conversion from one TZ to another except when dealing with daylight savings time. I'm really not sure what to do here... Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238038 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
