Status/Resolution/Reason: Closed/Fixed/Fixed
Reporter/Name(from Bugbase): / ext-user ()
Created: 10/27/2016
Components: Language, Functions
Versions: 2016,11.0,10.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: 10,0,21,300068 / 302319 302325
Priority/Frequency: Major / Few users will encounter
Locale/System: English / Mac 10 All,Win XP All
Vote Count: 0
Problem: Lastmodified is like "2016-10-17 10:11:40" and DateFormat cannot parse it
Method: Run the following sample:
<CFSET sDirFileGetQuery="SELECT {ts '2016-10-17 10:11:40'} as Lastmodified, getdate() as Now"> <CFQUERY name="qDirFileGet" datasource="SQLExpress">
#PreserveSingleQuotes(sDirFileGetQuery)#
</CFQUERY>
<CFDUMP var="#qDirFileGet#">
<CFSET sLastmodified = DateFormat(qDirFileGet.LastModified, 'yyyy/mm/dd')>
<CFDUMP var="#sLastmodified#">
The above example gives error " Invalid date or time string". This is also occurring in CF11 Update 10 and CFF2016 Update 3.
Result: Invalid date or time string
Expected:
Workaround: Use older macromedia_drivers.jar
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4197126
Reason: BugVerified
External Customer Info:
External Company:
External Customer Name:
External Customer Email:Attachments:
Comments: