Minutes Between Dates

[Augusto Cesar Castoldi]

HelpHi.

I'm using the timestamp format (AAMMDDHHMMSS) on my session.

how can I know the minutes between two dates.

I'm doing:
     =20
      $date       =3D $row_secao['date'];
      $date_now=3Ddate("ymdHis");   =20
      $x=3D$date_atual-$date;
      if ($x > 1000) {
        echo "Session expired.";  =20
      }
      =20
but I have a problem when turns the hour, like this:

date=3D010803105958
date_now=3D010803110518

the sub is 4500 (45 minutes!), but in fact, the real time between is 6   =
=20
minutes...

is there any function in mysql that does it?

thanks.

Augusto