`TO_CHAR({fieldid},'MM/DD/YYYY')`
# general
s
TO_CHAR({fieldid},'MM/DD/YYYY')