Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1624012456436-17e94cb2-28a7-3b02-5a0b-ce0e4a4d7ba5.cfm

Created June 18, 2021 10:39
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 trycf/a9866532c9dd489fd05984385f4a9b1d to your computer and use it in GitHub Desktop.
Save trycf/a9866532c9dd489fd05984385f4a9b1d to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1624012456436-17e94cb2-28a7-3b02-5a0b-ce0e4a4d7ba5.cfm
<cfscript>
dates = queryNew(
"date",
"date",
[
[createDate(2011, 3, 24)],
[createDate(2016, 8, 17)]
]
)
dateParts = queryExecute(
"SELECT MONTH(date) AS month, YEAR(date) AS year FROM dates",
{},
{dbtype="query"}
)
writeDump(dateParts)
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment