Format date!!

i'm confuse use the date format........anyone can help me?

let's say i want get 2day date in format (dd-mm-yyyy).............

Try:
DATE_FORMAT(now(), '%d - %m - %Y')
All you have to do is put the date field you want to format in the first parameter

date time functions

Yak, this is PHP :p

Today's date:

date("d-m-Y");

By default date is now, otherwise, the syntax is :

date ( string format [, int timestamp] )

Quote:

---

Originally Posted by kenny_oh

i'm confuse use the date format

---

Means mysql to me :D