note 56679 added to function.mssql-query

To get column of type datetime as varchar in format: "YYYY-MM-DD" you should use: $query = "SELECT CAST(DATEPART(YYYY,row_date) AS CHAR(4)) + '-' + RIGHT(CAST(100+DATEPART(MM,row_date) AS CHAR(3)),2) + '-' + RIGHT(CAST(100+DATEPART(DD,row_date) AS CHAR(3)),2) + '' AS row_date, FROM TABLENAME WHERE id = '$id'"; (Where "row_date" is of type datetime) ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+56679 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+56679&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+56679&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+56679&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+56679&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+56679&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+56679&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+56679&report=yes Search -- http://master.php.net/manage/user-notes.php