extracting unix time from a given time

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

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:

extracting unix time from a given time

Post 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
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:

Post by pelegk2 »

found how to do it :
FROM_UNIXTIME(".$row_round['date'].",'%Y-%m-%d 00:00:00')
Post Reply