Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save trycf/2fb824a4c83c2243a152139e9a2e6e4f to your computer and use it in GitHub Desktop.
Save trycf/2fb824a4c83c2243a152139e9a2e6e4f to your computer and use it in GitHub Desktop.
TryCF Gist
<cfscript>
errors = queryNew(
'etime',
'date',
[
[createDate( 2023, 1, 1 )],
[createDate( 2024, 1, 1 )],
[createDate( 2025, 1, 1 )]
]);
dump( queryExecute( "
select * from errors
WHERE etime BETWEEN '2023-12-22 19:17:44.0' AND '2024-01-21 19:17:44.0'
", [], {dbtype:'query'}) )
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment