formatting yy-mm-dd to dd-mm

[tamayo]

hi, what is the way to format mysql date field yy-mm-dd to dd-mm?

regards

[jeepin81]

I'm not really sure what you are asking... You want to display it like dd-mm or save it like that? If it is display you can use substr like:

$b = '2012-01-01';
echo substr($b, 4);

[Weedpacket]

The first place to look should probably be the MySQL's manual page on date and time functions.