query with unixtime and compering the date
Posted: Wed May 18, 2005 6:09 am
i have made this select :
when i run this query i get result like 29/04/2005
and so on!
why is that?
thnaks i nadvance
peleg
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