This is my table. CREATE TABLE Sales( store_name VARCHAR(50), Sales DECIMAL(10,2), Date DATE); But I can insert into the table Date fields in the format of YYYY-MM-DD only.But I want to get the output to the browser in the form of for example Jan-05-1999.And also how to get the sales value without decimal parts?
I don't know how to format the dates in MySQL. This forum is for Microsoft SQL Server, so I would be surprised if there are many here who know MySQL. But, just a quick googling brought me to this page, which has the various format strings and examples: http://www.w3schools.com/sql/func_date_format.asp