Hope this helps:
select min(ctime), max(ctime) from tbl_a where ctime != "0000-00-00
00:00:00"
Best regards,
Diego
----- Original Message -----
From: "Xiaobo Chen" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, March 13, 2006 11:17 AM
Subject: simple query
Hi, all
I have a table which has a column with "time". It's format is like
"0000-00-00 00:00:00" (default value). I want to get the minimum and
maximum values for this cloumn. Obviously, "0000-00-00 00:00:00" isn't the
minimum value I want.
What I did for the "minimum" time, suppose the column name is "ctime", the
table name is "tbl_a":
select ctime form tbl_a where ctime<>"0000-00-00 00:00:00" order by ctime
limit 1;
Using this query, I am able to get the "minimum" time value. But what is
the query for "max" time value? I guess it's something about reverseing
the "order by", but I couldn't find it.
Could anyone please give me a hand?
Thanks a lot.
Xiaobo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__________ InformaciĆ³n de NOD32 1.1440 (20060312) __________
Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com
___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]