Date yyyy-mm-dd hh:mm:ss

[Anon]

When retrieving data from an Access database, date fields are read in a yyyy-mm-dd hh:mm:ss format.

In the database, the fields are stored as yyyy-mm-dd, so all these fields get 00:00:00 appended when displayed.

How do I display these fields in a yyyy-mm-dd format?

[Anon]

maybe:

echo date("Y-m-d", mktime(0,0,0,$month,$day,$year));

[Anon]

or

echo ereg_replace("00:00:00","",$date_var);

[Anon]

In this case, I would DEFINATELY use str_replace, it is expontially faster than ereg_replace, and since your not using a regular expression, why bother?

Chris