Select only date from datetime?
Posted: Sat May 13, 2006 4:27 pm
Is there a function i should use to return the date only from a datetime field?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
mysql> select date(now());
+-------------+
| date(now()) |
+-------------+
| 2006-05-14 |
+-------------+
1 row in set (0.03 sec)