List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 25 1999 7:25am
Subject:Re: TIMESTAMP in where clause
View as plain text  
>>>>> "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
Thread
TIMESTAMP in where clauseSurat Singh Bhati24 Sep
  • Re: TIMESTAMP in where clauseBob Kline24 Sep
Re: TIMESTAMP in where clauseSurat Singh Bhati24 Sep
  • Re: TIMESTAMP in where clauseBob Kline24 Sep
  • Re: TIMESTAMP in where clauseBob Kline24 Sep
  • Re: TIMESTAMP in where clauseMichael Widenius25 Sep