convert datetime for math

RickyD77

how can i convert this 2003-07-05 18:30:00 from my db to calculate the diferrence in second betwen now() an 2003-07-05 18:30:00

thx

cosminb

you could use time_to_sec() function
or unix_timestamp()

I suggest to use the second one

RickyD77

thx would you just give me some clue on how to convert it

thx

cosminb

select unix_timestamp(now()) - unix_timestamp("2003-07-05 18:30:00");

this will give you the difference in seconds between now and "2003-07-05 18:30:00"

RickyD77

ok but unix_timestamp() is a sql function not php function right???

cosminb

yes, it's a sql function

RickyD77

so there is my code but it dosent work

<?
include('lib.php');
connect();
$today = date("Y-m-j");
$q="select UNIX_TIMESTAMP('free_stop') as time FROM live_show WHERE live_date <= '$today'";
$result = mysql_query($q) or die(sqlerrmessage($q));
$r = mysql_fetch_array($result);

cosminb

I'm not sure I know what you're trying to do ...
Maybe you could explain it a little bit more

RickyD77

ok thats simple i have a live show table where i have a start and end time when the show is finish i need to refresh the page so here we go

when the user enter i stock is enter time than

i sort the the end time from the db so i want to how time it left before i refresh

$timeleft = $endtime - $entertime

than i need to put this value in this

but i cant sort my time to do this simple math things as you know my time is stock in datetime format

thx eric
i very apreciate your help

cosminb

$query='select unix_timestamp(now())- unix_timestamp(startTime) as timeleft from your_table where ....';