Page 1 of 1

query with unixtime and compering the date

Posted: Wed May 18, 2005 6:09 am
by pelegk2
i have made this select :

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 desc

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

Posted: Wed May 18, 2005 11:48 am
by neophyte
Are you trying to change a date/time stamp into a unix time?