query with unixtime and compering the date

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

query with unixtime and compering the date

Post 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
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post by neophyte »

Are you trying to change a date/time stamp into a unix time?
Post Reply