Getting Truncated DateTime in query results
Posted on 2004-11-29
I am running the following query but am getting only the first 8 characters in the date results.
I have tried "Select ID,[DATESTAMP] as DateFormat(DTGSubmit, 'mm/dd/yyyy hh:mm:ss')....." but get the following error:
"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."
<cfquery name="getDFI" datasource="#DBPath#" dbtype="OLEDB" provider="Microsoft.Jet.OLEDB.4.0"
providerdsn="#DBPath#" username="Admin" password="">
Select ID, DATESTAMP,Test,[Date] as PDate FROM t_CPoF_Interview