Format date!!

[kenny_oh]

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

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

[{yak}]

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

[sebs]

Yak, this is PHP

Today's date:

date("d-m-Y");

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

date ( string format [, int timestamp] )

[{yak}]

i'm confuse use the date format

Means mysql to me