px_timestamp2string

(PECL paradox >= 1.4.0)

px_timestamp2string — Converts the timestamp into a string

说明

px_timestamp2string ( resource $pxdoc , float $value , string $format ) : string

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

参数

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).

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #1 Turn a paradox timestamp into a human readable form

<?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 miliseconds since 0001-01-02 */
$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);
?>

以上例程会输出：

7/15/1917
7/15/1917 01:00:00

The Julian day count as passed to jdtogregorian() has a different base of 1.1.4714 b.c. and must therefore be calculated by adding 1721425 to the day count used in the paradox file. Turning the day count into a timestamp is easily done by multiplying with 86400000.0 to obtain miliseconds.

参见

相关文章
php dba 函数 splits a key in string representation into array representationphp informix 函数 writes a string into the slob objectphp imap 函数 converts iso 8859 1 string to modified utf 7 textphp ldap 函数 convert ldap error number into string error messagephp maxdb 函数 escapes special characters in a string for use in an sql statement taking into account the current charset of the connectionphp mssql 函数 converts a 16 byte binary guid to a stringphp mysqlnd uh 函数 converts a mysql connection handle into a mysqlnd connection handlephp ncurses 函数 put terminal into halfdelay modephp ncurses 函数 display the string on the terminal in the video attribute modephp paradox 函数 converts a date into a stringphp paradox 函数 deletes resource of paradox databasephp paradox 函数 inserts record into paradox databasephp paradox 函数 stores record into paradox databasephp paradox 函数 sets the name of a table deprecated php paradox 函数 converts the timestamp into a stringphp radius 函数 converts raw data to integerphp radius 函数 converts raw data to stringphp simplexml 函数 interprets a string of xml into an objectphp svn 函数 imports an unversioned path into a repositoryphp com 函数 converts a variant date/time value to unix timestamp
关注编程学问公众号