>>>>> "Surat" == Surat Singh Bhati <surat@stripped> writes:
Surat> I have tested it with and without (single and double) quotes....
mysql> select max(timest) from city;
Surat> +----------------+
Surat> | max(timest) |
Surat> +----------------+
Surat> | 19990924233028 |
Surat> +----------------+
Surat> 1 row in set (0.22 sec)
mysql> select cityname from city where timest ='1999-09-24 23:30:28';
Surat> Empty set (0.00 sec)
mysql> select cityname from city where timest ='19990924233028';
Surat> Empty set (3.07 sec)
mysql> select cityname from city where timest ="19990924233028";
Surat> Empty set (0.06 sec)
Hi!
Could you please try:
select max(concat(timest)) from city;
select timest from city order by timest desc limit 1;
select cityname from city where timest+0=19990924233028;
I want to know if this is a problem with the MAX() function or the
SELECT
Regards,
Monty
