px_timestamp2string

Converts the timestamp into a string. (PECL paradox:1.4.0-1.4.1)
string px_timestamp2string ( resource pxdoc, float value, string format )

Turns a timestamp as it stored in the paradox file into human readable format. Paradox timestamps are the number of milliseconds since 1.1.0000. This function is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the following example.

Parameters

pxdoc: Resource identifier of the paradox database.
value: Value as stored in paradox database field of type PX_FIELD_TIME, or PX_FIELD_TIMESTAMP.
format: String format similar to the format used by date(). The placeholders support by this function is a subset of those supported by date() (Y, y, m, n, d, j, H, h, G, g, i, s, A, a, L).

Return Values

Returns TRUE on success or FALSE on failure.

Examples

Example 1706. Turn a paradox timestamp into a human readable form

copy to clipboard

<?php

$px = px_new();

/* make up a date as it could be stored in */

/* a date field of a paradox db. */

/* 700000 days since 1.1.0000. */
$days = 700000;

/* Use the calendar functions to print a */

/* human readable format of the date */
echo jdtogregorian($days+1721425)."\n";

/* Turn it into a timestamp as it stored in a paradox database */

/* Timestamps are stored in milli seconds since 1.1.0000 */
$stamp = $days * 86400.0 * 1000.0;
/* Add one hour */
$stamp += 3600000.0;
/* The following will output '7/15/1917 01:00:00'. */
echo px_timestamp2string($px, $stamp, "n/d/Y H:i:s")."\n";

px_delete($px);
?>

The above example will output: