okay, this is just me thinking out loud... none of this is tested...
basically,
- take the string
- get rid of the last 3 chars (eg .75)
- split on ' days, '
- split the 2nd half on ':'
- multiply each bit (days, hrs, mins) by the appropriate no of seconds
- add it all together to get a number
I don't think you can use strtotime in that case. However, assuming that
your data is properly formatted every time, you can use a simple
function like this (I'm doing it from memory, so it might not actually
work):
Hope this helps.
Cheers,
Marco
--
php|architect - The Magazine
I have two periods in time from a Cisco router that I would like to find the
difference in seconds. I am not sure the best way to do this since it is not
a date, but rather an amount of time since last reset.
Here is the numbers
181 days, 7:11:06.66
//stands for 181 days, 7 hours, 11 minutes, 6.6
id=$id
>
> I'm not sure what
> select date1-date2 as date_diff
> returns?
>
> beware of the 2037 limitation using UNIX_TIMESTAMP()
>
> regards
> Jeff
>
>
>
> -Original Message-
> From: BlackLord [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, Ma
: Thursday, March 22, 2001 5:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Date subtraction
Hi!
I want to subtract to date times from each other. Like :
'2000 12 01 12:12:12' - '2000 11 10 11:39:59'
Is there any function to do this subtraction or can i do it with MySQL'
PERIOD_DIFF(P1,P2)
or convert them both tu unix_time(p1) - unix_time(p2) then you can have
seconds and format them as you want
almir
""BlackLord"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
99dcs5$cbh$[EMAIL PROTECTED]">news:99dcs5$cbh$[EMAIL PROTECTED]...
> Hi!
>
> I want to subtract to date tim
Hi!
I want to subtract to date times from each other. Like :
'2000 12 01 12:12:12' - '2000 11 10 11:39:59'
Is there any function to do this subtraction or can i do it with MySQL's
SELECT query ?
Thanks
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECT
7 matches
Mail list logo