px_date2string

(PECL paradox >= 1.4.0)

px_date2string — Converts a date into a string

说明

px_date2string ( resource $pxdoc , int $value , string $format ) : string

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();

/* 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";
/* px_date2string() outputs the same */
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历法日期

add a note

User Contributed Notes 1 note

down

john dot navratil at sbcglobal dot net ¶

8 years ago


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

}

?>

add a note

官方地址：https://www.php.net/manual/en/function.px-date2string.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络数据库 JAVA 面试 NoSQL C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 ADORecordSet对象 adodb手册 opcache预加载 Composer的Packagist资源 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet mysql面试题 PHP json解析（json_decode）页面工具 php中几种注释规范纯php实现DES以及TripleDES加密算法 PHP5 扩展SOAP 调用 webservice [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 [原创]诡异的php-fpm超时问题两千行PHP学习笔记

略微加速

PHP官方手册 - 互联网笔记

px_date2string

说明

参数

返回值

范例

参见

User Contributed Notes 1 note