comparacion defechas mysql
| From: | Eduardo Garcia | Date: | Fri, 02 Feb 2001 23:47:41 +0000 |
| Subject: | comparacion defechas mysql | ||
| Groups: | php.general.es | ||
| Request: | Send a blank email to general-es+get-6702@lists.php.net to get a copy of this message | ||
Hola lista tengo la siguiente tabla>
CREATE TABLE horoscope (
hid int(10) unsigned NOT NULL auto_increment,
name varchar(50),
thetext text,
bdate timestamp(6) DEFAULT '00-00-00' NOT NULL,
edate timestamp(6) DEFAULT '00-00-00' NOT NULL,
PRIMARY KEY (hid)
);
con los siguientes registros":
insert into horoscope
values(NULL,"Acuario","","000121","000219");
insert into horoscope
values(NULL,"Piscis","","000220","000321");
insert into horoscope
values(NULL,"Aries","","000322","000420");
insert into horoscope
values(NULL,"Tauro","","000421","000521");
insert into horoscope
values(NULL,"Geminis","","000522","000622");
insert into horoscope
values(NULL,"Cancer","","000623","000723");
insert into horoscope
values(NULL,"Leo","","000724","000823");
insert into horoscope
values(NULL,"Virgo","","000824","000923");
insert into horoscope
values(NULL,"Libra","","000924","001023");
insert into horoscope
values(NULL,"Escorpion","","001024","001122");
insert into horoscope
values(NULL,"Sagitario","","001123","001222");
insert into horoscope
values(NULL,"Capricornio","","001223","000120");
y la siguiente consulta:
select hid,thetext from horoscope where bdate <= 000202 and edate >= 000202;
Bajo mi logica deberia devolver Piscis, pero no devuelve Acuario que podra
ser.
gracias por todo.
enzo
Eduardo Garcia
Cel: 6585836
Icq: 69885612
Santa Marta - Magdalena
Colombia - Sur America
Usuario Linux # 164529
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1