I have an PHP script to extract to a CSV. I am trying to get the date to come out as MMDDYY. When I run it now I get the date and time.
Example: 2015-08-28 09:39:27.
I want this to be 082815
This is my query:
$select_table=$mysqli->query("SELECT tom.OrderNumber,tom.PartNumber,tom.DateOrdered,4 as HardCodedField,tom.QtyOrdered,tom.LineItemApproved FROM `tblorderlineitem` tom ");
Can I use something in my select statement to make date come out this way?