List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:May 25 1999 6:29pm
Subject:Re: Dates querying Mysql
View as plain text  
Claudia M. Castaneda wrote:
> 
> Hi:
> Thanks for your reply but...
> 
> mysql> select obs_id, obs_URI, obs_source, beg_date, beg_time from
> observation where beg_date between 19990120 and 19990530;
> Empty set (0.21 sec)
> 
> and you can see that there is data within this range:
> 
> mysql> select obs_id, obs_URI, obs_source, beg_date, beg_time from
> observation where beg_date between '1999-01-20' and '1999-05-30';
> 

Try the 1st with a +0:
mysql> select obs_id, obs_URI, obs_source, beg_date, beg_time from
observation where beg_date+0 between 19990120 and 19990530;
                          ^^
  jim...
Thread
Dates querying MysqlClaudia M. Castaneda24 May
  • Re: Dates querying MysqlGraeme B. Davis25 May
  • Re: Dates querying MysqlChristian Mack25 May
    • Re: Dates querying MysqlClaudia M. Castaneda25 May
      • Re: Dates querying MysqlJim Faucette25 May
        • Re: Dates querying MysqlClaudia M. Castaneda25 May
          • Re: Dates querying MysqlVivek Khera25 May
        • Re: Dates querying MysqlJim Faucette25 May
          • Re: Dates querying MysqlMichael Widenius2 Jun
            • Re: Dates querying MysqlVivek Khera2 Jun
              • Re: Dates querying MysqlMichael Widenius3 Jun
Re: Dates querying MysqlVivek Khera2 Jun