I am trying to use a SELECT query to retrieve the earliest and the latest date/ time entries from my table. The field is a datetime (YYYY-MM-DD HH-MM-SS). I cannot find anything related to querying datetime in the MySQL manual.
What is the proper way to approach this?
When I do a $firstdate = mysql_query("SELECT MIN(datestamp) from seminar")
and then echo $firstdate I get the following
Resource id #5