if its ALREADY stored in trini-time, then id figure out what the UTC offset is for that, store it in an application variable, and then with javascript, figure out where the user is in relation utc, set a javascript cookie for that utc offset (which is retrievable via cf as well), then with those two offsets, come up with the right time to show the user.
ras On Tue, Aug 24, 2010 at 4:02 PM, Cameron Childress <camer...@gmail.com> wrote: > > In MS SQL I think you can use SYSUTCDATETIME() to get the UTC Date and Time. > > Medic mentioned *not* using the SQL Server date and time, but I > actually usually *do* use the SQL Server Date/Time since I know it's > typically doing to be consistent. Otherwise in an environment where > you have clustered CF servers feeding one DB you may have different > time settings on each CF box, plus the machine SQL sits on. Easy > enough to use a time service to sync all the time clocks, but > sometimes you don't have that ability. > > Personal preference I suppose, as long as it's consistent... > > -Cameron > > On Tue, Aug 24, 2010 at 3:48 PM, Vivec <gel21...@gmail.com> wrote: >> >> Ok...I see where it is stored. >> >> In the MS SQL database for the dateadded field there is a Default Value of: >> >> (getdate()) >> >> :-\ >> >> sooo....uhhh...what do I do now :-| >> >> On 24 August 2010 15:28, Jacob <ja...@excaliburfilms.com> wrote: >> >>> >>> Use UTC time for transactions and storage?munity/unsubscribe.cfm >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:325858 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
