Correct. Replace the 'T' with a space, and drop the '-NNNN' bits. On Mon, Apr 16, 2012 at 11:46 AM, Russ Michaels <[email protected]> wrote:
> > 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:350713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
