you can use any programmin language to manipulate...
i did the following in PHP...
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//###################################################################################################################
// Function to calculate remaining days, hours,
minutes and seconds between current date and end
date..
// Returns the remaining time .. in days or hrs or
mins or secs...
//###################################################################################################################
function
CalRemTime($ClosingDay,$ClosingMonth,$ClosingYear)
{
$ClosingTime =
mktime(24,60,60,$ClosingMonth,$ClosingDay,$ClosingYear);
$TimeDifference = $ClosingTime - time();
$RemainingDays = ($TimeDifference - ($TimeDifference
% 86400)) / 86400;
$TimeDifference = $TimeDifference - ($RemainingDays *
86400);
$RemainingHours = ($TimeDifference - ($TimeDifference
% 3600)) / 3600;
$TimeDifference = $TimeDifference - ($RemainingHours
* 3600);
$RemainingMinutes = ($TimeDifference -
($TimeDifference % 60)) / 60;
$TimeDifference = $TimeDifference -
($RemainingMinutes * 60);
$RemainingSeconds = ($TimeDifference -
($TimeDifference % 1)) / 1;
if($RemainingDays>0)
{
$sValue = "$RemainingDays days";
return $sValue;
}
else
{
if($RemainingHours>0)
{
$sValue = "$RemainingHours hrs:$RemainingMinutes
mins:$RemainingSeconds Secs";
return $sValue;
}
else
{
if($RemainingMinutes>0)
{
$sValue = "$RemainingMinutes
mins:$RemainingSeconds Secs";
return $sValue;
}
else
{
if($RemainingSeconds>0)
{
$sValue = "$RemainingSeconds secs";
return $sValue;
}
else
{
$sValue = "Bidding time is over...";
return $sValue;
}
}
}
}
}
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Shankar
------
--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> * YC Nyon
> > I need to get the time/date (ie. 1 day 12 hours 11
> min 4sec)
> > between 2 time dates.
> > Can't seem to find any of these functions in the
> Mysql manual. The nearest
> > was Period_diff() which is calculating months
> elapsed.
>
> I don't think you can do it directly, you have to
> split the day and time
> part, and calculate the two things separately: The
> number of days between
> the two dates AND the difference in the
> HH:MM:SS-part of the two dates.
>
> HTH,
>
> --
> Roger
>
>
>
---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list
> archive)
>
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
