Using STR_TO_DATE() to get US Date Format

[websteve]

I have this Insert statement that converts the US date to the MySQL standand date format:

 

$pur="INSERT INTO Purchasing(ID, Item, Description, Quantity, Price, Date, AMPM) VALUES ('$cust_id','$item_a','$description_a','$quantity1','$price1',STR_TO_DATE('$date', '$datefilter'),'$ampm')";

 

$datefilter = '%m/%d/%y'; and the $date variable is received from a HTML form and it works fine.

 

But now, I'm trying to figure out how to do it in reverse, such as if I was to Select the date from the database and display it on the screen in US format? I can't seem to find the correct function.

 

Any help would be appreciated.

 

Thanks!

[kickstart]

Hi

 

Think the function you want to use is date_format.

 

All the best

 

Keith

[websteve]

Thanks. I googled data_format for additional info and I can figure it out from here. If I have any additional questions, I'll resend a message; otherwise, looks good.

 

Thanks!

[otuatail]

you could set your table to insert the current date for you automaticaly

 

OrderDate datetime NOT NULL DEFAULT CURDATE(),

 

[otuatail]

sorry that is outdated you should use

 

OrderDate datetime NOT NULL default CURRENT_TIMESTAMP,

 

Desmond.

 

[PFMaBiSmAd]

otuatail, That has nothing to do with the question and since you cannot use functions as default values for datetime data types, it's invalid as well.

 

If the column happened to be a TIMESTAMP data type, you could use default values that are a few of the mysql function names, but that is not what the OP is doing or asking about.