px_date2string
(PECL paradox >= 1.4.0)
px_date2string — Converts a date into a string.
说明
$pxdoc
, int $value
, string $format
)Turns a date as it stored in the paradox file into human readable format. Paradox dates are the number of days 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 example below.
参数
-
pxdoc -
Resource identifier of the paradox database as returned by px_new() .
-
value -
Value as stored in paradox database field of type PX_FIELD_DATE.
-
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, L).
返回值
成功时返回 TRUE ， 或者在失败时返回 FALSE 。
范例
Example #1 Turn a paradox date into a human readable form
<?php
$px = px_new ();
$days = 700000 ;
echo jdtogregorian ( $days + 1721425 ). "\n" ;
echo px_date2string ( $px , $days , "n/d/Y" ). "\n" ;
px_delete ( $px );
?> 以上例程会输出：
7/15/1917 7/15/1917
参见
- px_timestamp2string() - Converts the timestamp into a string.
- jdtogregorian() - 转变一个Julian Day计数为Gregorian历法日期
用户评论:
[#1] john dot navratil at sbcglobal dot net [2010-12-21 09:52:48]
Date fields are retrieved as the number of days since 0 A.D. (I think), but not as anything resembling a date. If you are exporting this data, you must used this function to convert. Read the schema first to determine which fields are date fields...
<?php
$schema = $pxdoc->get_schema();
$dateFields = array();
foreach ($schema as $key => $attrs) {
if ($attrs["type"] == PX_FIELD_DATE) // Collect list of "date" columns
$dateFields[] = $key;
}
?>
An export to a CSV format, for example, could them be written...
<?php
for ($rec = 0; $rec < $totRecs; ++$rec) {
$arr = $pxdoc->get_record($rec);
foreach ($dateFields as $key) {
$arr[$key] = $pxdoc->date2string($arr[$key], "m/d/Y");
}
fputcsv(STDOUT, $arr); // STDOUT only available with CLI
}
?>