Re: Dates querying Mysql

[Jim Faucette]

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...