[SOLVED] select with time
Posted: Wed Feb 23, 2005 5:48 am
i have this select
when i run this query and for example the
TAARICH_TEUDA=='23.02.2005 12:14:00'
this value shouldn't been show beacuse i asked for
any idea?
thnaks in advance
peleg
Code: Select all
SELECT from_unixtime(TAARICH_HASPAKA),from_unixtime(TAARICH_TEUDA,'%d.%m.%Y %h%:%i:%s'),sent FROM order_header WHERE TAARICH_TEUDA!=''and from_unixtime(TAARICH_TEUDA,'%d.%m.%Y %h%:%i:%s')<'23.02.2005 8:00:00'TAARICH_TEUDA=='23.02.2005 12:14:00'
this value shouldn't been show beacuse i asked for
Code: Select all
from_unixtime(TAARICH_TEUDA,'%d.%m.%Y %h%:%i:%s')<'23.02.2005 8:00:00'thnaks in advance
peleg