a built-in php function to grab a datetime and output just the date

[webslinga]

hey all,
I would like to know if there is a php built-in function that grabs a datetime field from a MySQL table and outputs JUST the date { i.e - 2006-07-30 } without the time value. Thanks in advance.

 

[sleipnir214]

A builtin function to do that one specific thing? No.

But PHP has functions to connect to a MySQL server, send a query and deal with the returned data. See

http://www.php.net/manual/en/function.mysql-fetch-assoc.php

As far as taking a MySQL datetime field and returning just the date, you can either use PHP's date() and strtotime() functions or use MySQL's builtin date() function.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[KarveR]

to elaborate on sleipnir214:

SELECT date(your_date-time-field) FROM ....

K

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[webslinga]

Thanks guys. I worked it out with the date helper functions in the symfony framework. Thanks again for all your help.