extracting unix time

[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

[onion2k]

1. You'll need two timestamps, one for the start time and one for the end.

2. You can make a timestamp for 00:00:00 22/12/2004 .. that'd technically be the timestamp for 22/12/2004.

BTW.. when you say "query" do you mean website query, or database query?

[pelegk2]

and this is the solution :

FROM_UNIXTIME(".$row_round['date'].",'%Y-%m-%d 00:00:00')