Is there a reason you insist on using a CHAR field, instead of a TIME
field, which would make this all easier and allow you to use the
multitude of MySQL Date and Time Functions in your query... ???
> -----Original Message-----
> From: juaid [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 07, 2002 2:02 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] convertion from string to time & substracting
> sorry if maybe this is a bit dumb question, but I'm a begginer with
> I got a mysql database, where two of the fields of a table record
> CHAR(8) in the format hh:mm:ss
> I want to take this two times and get the difference between them in
> seconds, for example 12:01:30 - 12:00:00 = 90
> I looked up at the doc in the php.net website and couldn't get on how
> this... should I use the strtotime function?
> anyone has donde something like this, or knows what functions could
> to do this?
> Thanks in advance,
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php