dateAdd() function in sql server would transform it for ya... sure On Wed, Aug 25, 2010 at 12:45 PM, Vivec <[email protected]> wrote: > > Hmm...well..all the javascript etc. sounds great. > But... > Is there SQL code that will take the GMT time , and then subtract 4 hours > from it so that it corresponds to -4 G.M.T. ? > And I can store that value into the database. > > I'm taking over this application from another developer, and the time to > adjust every single page that displays the time is going to be a lot. > This all needs to come together for Friday :-\ > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325874 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
