Extracting info from dates

spraveens · September 18th, 2004, 02:01 PM

Hi

I would like to know How do I extract the Minutes or seconds etc from a given date. ex: if the Date is "18/9/2004 7:58:43 PM" , How do I extract the Minutes [i.e. 58] from the date and assign to another variable.

Thx

Praveen.

Moharo · September 18th, 2004, 03:47 PM

use the get_date() function.....

http://pl.php.net/manual/en/function.getdate.php

www.campusgrind.com the college portal

Snib · September 18th, 2004, 04:14 PM

Hello Moharo,

I don't see how that would help Praveen with his problem.

Praveen,

If the date format is always like that, you could try a function like this:

Code:

function getMinutes($date)
{
    $minutes = explode(":",$date);
    return $date[1];
}
$minutes = getMinutes($your_date_variable);

HTH!

-Snib <><
http://www.snibworks.com
There are only two stupid questions: the one you don't ask, and the one you ask more than once :-)

richard.york · September 19th, 2004, 02:00 AM

Use the strtotime function, this tries to create a Unix timestamp from any date string. Once you have a Unix timestamp you can format it any way you like using the date function.

http://www.php.net/strtotime
http://www.php.net/date

HTH!

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

Moharo · September 19th, 2004, 09:59 AM

Snib

sorry for being uninformative.. this is what i meant:

function getTheJuicyMeat($date)
{
   $date = getdate(strtotime($date));
   return $date["minutes"]; // if you want the minutes
   // return $date["seconds"]; // if you want seconds
}

you can substitute "getTheJuicyMeat" with anything you like :)

peace

www.campusgrind.com the college portal

spraveens · September 20th, 2004, 01:56 AM

Hi

I have 2 time values ,i.e. 11:09 am and 11:45 am, Now How do I get the difference between these two values i.e. 36 minutes?

Thanks
Praveen.

richard.york · September 20th, 2004, 02:40 AM

The easiest thing to do is use two complete dates i.e. Monday, September 20, 2004 11:09 AM and Monday September 20, 2004 11:45 AM, convert those dates to unix time and subtract one from the other.

Unix time is the number of seconds elapsed since the Epoch (00:00:00 UTC January 1, 1970). Once you have the difference between the two that number will be the number of seconds of difference between the two dates, then it's a matter of converting that number to a sensible time measurement.

HTH!

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

spraveens · September 20th, 2004, 06:30 AM

Thx for the reply ,
My dates are : 04:41:23 1-20-2004 , the Unix Time stamp is :1095635478,
04:19:40 1-20-2004 , the Unix time Stamp is : 1095677340 Now I would like to have the Difference of the above 2 unix time stamps, ideally I should get 22 minutes ,when I subtract the second value from the first one I get a value of -41862 [a negative value] . Please let me know How do I get the correct difference and also if Iam wrong any where.
Thx.
Praveen