Page 1 of 1

extracting unix time from a given time

Posted: Tue Dec 21, 2004 4:14 am
by pelegk2
i have this time for example :
1103670000 which =22/12/2004 1:00:00
is it possble some how in a query to recive this date
but in the start and end of the date like this :
22/12/2004 00:00
and
22/12/2004 23:59:59

but both in unixtime?
or its too complicated?
2)can i get only the unix time of the date : 22/12/2004 as part of the query


thnaks i advance
peleg

Posted: Tue Dec 21, 2004 7:26 am
by pelegk2
found how to do it :
FROM_UNIXTIME(".$row_round['date'].",'%Y-%m-%d 00:00:00')