Skip to content

Instantly share code, notes, and snippets.

@GiancarloGomez

GiancarloGomez/createODBCDateTimeError.cfc

Created March 5, 2019 15:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save GiancarloGomez/909eb3c10bc48466c772eeebb2010938 to your computer and use it in GitHub Desktop.
Save GiancarloGomez/909eb3c10bc48466c772eeebb2010938 to your computer and use it in GitHub Desktop.
Download ZIP
ColdFusion 2018 ODBC Date Error
Raw
createODBCDateTimeError.cfc
// this is for example purpose only. Not actual values used
today = "01/01/2019";
// use to work but generates an error now
createODBCDateTime(today & "23:59:59");
// throws 01/01/201923:59:59 is an invalid date or time string.
// required fix ( add the required space )
createODBCDateTime(today & " 23:59:59");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment