 <p>If the date_promised field is of a DATETIME type you can use -</p> <pre><code>SELECT date_promised, DATE_FORMAT(date_promised, '%m/%d/%Y') AS date_promised2 FROM erp_workorder AS t1 WHERE id_primary = 73135; </code></pre> <p>If the date_promised field contains a unix timestamp you can use -</p> <pre><code>SELECT date_promised, DATE_FORMAT(FROM_UNIXTIME(date_promised), '%m/%d/%Y') AS date_promised2 FROM erp_workorder AS t1 WHERE id_primary = 73135; </code></pre>