Code: Select all
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 descwhen i run this query i get result like 29/04/2005
and so on!
why is that?
thnaks i nadvance
peleg