I think the T designates a timestamp and the -0700 is a timezone adjustment you could try just removing one or both of those and see if it helps.
On Mon, Apr 16, 2012 at 5:30 PM, John M Bliss <[email protected]> wrote: > > An API is sending dates in whatever format this is: > > 2012-04-14T22:58:51-0700 > > ...which does not automagically work with cfprocparam > cfsqltype="CF_SQL_TIMESTAMP" (to SQL Server). > > Before I "roll my own," does anyone know whether that format has a name > and/or of a cflib.org function that'll convert it? > > -- > John Bliss - http://about.me/jbliss > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
