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 <[email protected]> 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 <[email protected]> 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:325857 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
