Format date

[tdprout]

I currently have this

("SELECT * FROM material WHERE status='$status' AND category='$category' ORDER BY `material`.`title` ASC ");

Where do you stick this:

 
DATE_FORMAT(`date`,'%m/%d/%Y') AS showdate

While still using *? Or do I have to name all of the columns?

[Fou-Lu]

While you *should* name all the fields you want, it is not required. You can simply select the date format in combination with the *: SELECT *, DATE_FORMAT(`date`, '%m/%d/%Y') AS showdate. You'll still have the `date`, but also the `showdate` fields returned.

[nani_nisha06]

Originally Posted by tdprout

I currently have this

("SELECT * FROM material WHERE status='$status' AND category='$category' ORDER BY `material`.`title` ASC ");

Where do you stick this:

 
DATE_FORMAT(`date`,'%m/%d/%Y') AS showdate

While still using *? Or do I have to name all of the columns?

Hope below post will help you ....

http://www.codingforums.com/showthread.php?t=275610