hour

[Anon]

Hi,
I have to do a system that calculate the difference between two hours (14:30 - 12:00) and after this sum the result with outher sum.
Is there some function to do this on PHP ?? or in PostgreSQL ??

[[deleted]]

If you have just the two strings, you can use substr() to grab the hours and minutes from the two time-strings and do the calculations with them.

[hal9000]

Try:

$time1="14:30";
$time2="12:00";
list($time1h,$time1m)=split(":",$time1);
list($time2h,$time2m)=split(":",$time2);
$time1s=$time1h60+$time1m;
$time2s=$time2h60+$time2m;
$deltatime=$time1s-$time2s;

$deltatimestr=sprintf("%02d:%02d",floor(abs($deltatime)/60),abs($deltatime)-(floor(abs($deltatime)/60)*60));

Now $deltatime will hold the number of minutes between the times (with +/-) and $deltatimestr will hold it in format of "HH:MM" without +/-

//Nicke

[Anon]

In postgres is very simple:

select timestamp(date '1998-02-24',time '23:20')-timestamp(date '1
998-02-24',time '21:20');