query with unixtime and compering the date

[pelegk2]

i have made this select :

select TEUDAT_MISH,from_unixtime(TAARICH_TEUDA,'%d/%m/%Y') from order_header where from_unixtime(TAARICH_TEUDA,'%d/%m/%Y')>'18/05/2005' order by TEUDAT_MISH desc

when i run this query i get result like 29/04/2005
and so on!
why is that?
thnaks i nadvance
peleg

[devinemke]

i assume that TEUDAT_MISH is an integer field storing unix timestamps? if so:

SELECT TEUDAT_MISH, FROM_UNIXTIME(TAARICH_TEUDA,'%d/%m/%Y') FROM order_header WHERE TAARICH_TEUDA > 1116388800 ORDER BY TEUDAT_MISH DESC