Hi

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

Thanks
Praveen.

Dear Praveen tel me that which database are you using for getting time or you getting time from any client side script ?



Numan
--------------------------------------------------
Love is the most precious thing of this world. So find it and grab it!

Cross-post with: http://p2p.wrox.com/topic.asp?TOPIC_ID=19374
Please post replies there.

Regards,
Rich

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

Thx for the reply , [Iam using sql server 2000]
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

Don't cross-post. It's annoying. Anyone who cares enough about your question to answer is likely already subscribed to all of the PHP forums.

Regards,
Rich

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