timestamp

[EniGMistA]

Hi,
I have 2 timestamp. How can I retrieve hours, minutes and secont between
them?

--

EniGMistA

[Setec Astronomy]

EniGMistA wrote:

> I have 2 timestamp. How can I retrieve hours, minutes and secont
> between them?

Hi,
you mean UNIX timestamp or MySQL timestamp?

In the first case look [url]http://www.php.net/date[/url] , in the second case
loot [url]http://www.php.net/substr[/url]

--
I am what I am, I do what I can
L'uomo, conscio di sbagliare, persevera.

[EniGMistA]

> In the first case look [url]http://www.php.net/date[/url] , in the second case

> loot [url]http://www.php.net/substr[/url]

I know PHP site. I think that this is a math problem :)

--

EniGMistA

[Colin McKinnon]

EniGMistA wrote:

> Hi,
> I have 2 timestamp. How can I retrieve hours, minutes and secont between
> them?
>

something like:

$totseconds=$t2-$t1;
$sconds=$totseconds % 60;
$hours=(integer)($totseconds/3600);
$minutes=(integer(($totseconds % 3600)/60);

hth

C.

[EniGMistA]

> $totseconds=$t2-$t1;

> $sconds=$totseconds % 60;
> $hours=(integer)($totseconds/3600);
> $minutes=(integer(($totseconds % 3600)/60);

Thanks. Olny a mistake:
$minutes=(integer(($totseconds % 3600)/60); >
$minutes=(integer)(($totseconds % 3600)/60);

--

EniGMistA

[ehowman]

Hello - I followed this thread and checked the links provided, but a solution
is not obvious to me. I have a results page with this PHP code that displays
the raw timestamp data <td><?php echo $row_BookOrderList['OrderDate'];
?>&amp;nbsp; </td> I'd like it do display as mm-dd-yyyy. I've figured out how
to display the date, but not to convert the contents of a field just for
display purposes. Any help would be much appreciated. Thanks

[David Powers]

ehowman wrote:

> Hello - I followed this thread and checked the links provided, but a solution
> is not obvious to me. I have a results page with this PHP code that displays
> the raw timestamp data <td><?php echo $row_BookOrderList['OrderDate'];
> ?>&amp;nbsp; </td> I'd like it do display as mm-dd-yyyy. I've figured out how
> to display the date, but not to convert the contents of a field just for
> display purposes. Any help would be much appreciated. Thanks

As Micha suggested, you should use MySQL DATE_FORMAT() to extract the
date from the database. That way it will be already formatted the way
you want it.

In your SQL query, instead of OrderDate, use the following:

DATE_FORMAT(OrderDate, '%m-%d-%Y')

If you are using the Simple mode in the Recordset dialog box, click the
Advanced button. That will display your SQL query fully written out.
Simply alter "OrderDate" as shown above. That's all there is to it.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[ehowman]

Thank you for the very fast reply, you solved it! I was using the code in the wrong place and was missing a bit of the syntax.

Thank you for your time and effort.

Eric

[David Powers]

ehowman wrote:

> Thank you for the very fast reply, you solved it! I was using the code in the wrong place and was missing a bit of the syntax.
>
> Thank you for your time and effort.

Glad to have been of help. The date and time functions in MySQL can be a
little difficult to get your head around to begin with, but they're very
useful.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]