|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
date format x -> cfprocparam cfsqltype="ColdFusion SQL TIMESTAMP"
An API is sending dates in whatever format this is:John M Bliss 04/16/12 12:30 P I think the T designates a timestamp and the -0700 is a timezone adjustmentRuss Michaels 04/16/12 12:47 P Correct. Replace the 'T' with a space, and drop the '-NNNN' bits.Matt Quackenbush 04/16/12 12:48 P Yeah. I guess "own-rolled," in this case, is stupid-easy. :-) Thanks.John M Bliss 04/16/12 12:50 P Isn't timestamp the UUID and datetime the correct datatype?LRS Scout 04/16/12 12:48 P 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 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. ----- Excess quoted text cut - see Original Post for more ----- Correct. Replace the 'T' with a space, and drop the '-NNNN' bits. ----- Excess quoted text cut - see Original Post for more ----- Yeah. I guess "own-rolled," in this case, is stupid-easy. :-) Thanks. On Mon, Apr 16, 2012 at 11:48 AM, Matt Quackenbush <quackfuzed@gmail.com>wrote: ----- Excess quoted text cut - see Original Post for more ----- 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. ----- Excess quoted text cut - see Original Post for more -----
|
May 26, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
