note 82854 deleted from function.mssql-query by cmb

Note Submitter: hpainter at gmail dot com ---- I was tripped up by the fact that mssql_query() returns values for 'datetime' columns in an unusual format. In order to get your values returned in the usual 'YYYY-MM-DD HH:MM:SS' format, you can use the CONVERT function in your query like so: SELECT CONVERT(varchar, INVOICE_DATE, 121) AS INVOICE_DATE ... where 'INVOICE_DATE' is the name of the 'datetime' column. The available datetime conversion formats are listed here: http://msdn2.microsoft.com/en-us/library/aa226054(SQL.80).aspx