strange problem with SELECT
Posted: Thu Aug 26, 2004 3:46 am
i have this select :
the problem is that i ask for all the del_id>0 but for some strange reason i get del_id==0 !!!! why is that ?>
del_id is defind as int unsigend not null
what wrong
Code: Select all
SELECT * FROM order_h WHERE del_id>0 and (dt<=1093557599 AND dt>=1093471200 AND TEUDAT_MISH='') OR FROM_UNIXTIME(TAARICH_T,'%Y %d %m')=FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y %d %m') order BY region_id ascdel_id is defind as int unsigend not null
what wrong