Isn't timestamp the UUID and datetime the correct datatype? Been a while for me as I'm retired now, but I think I remember something like that.
On Mon, Apr 16, 2012 at 12: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:350712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
