px_timestamp2string(3) [php man page]

PX_TIMESTAMP2STRING(3)													    PX_TIMESTAMP2STRING(3)

px_timestamp2string - Converts the timestamp into a string.

SYNOPSIS

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

DESCRIPTION

	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.

PARAMETERS

	      o $pxdoc
		- Resource identifier of the paradox database.

	      o $value
		- Value as stored in paradox database field of type PX_FIELD_TIME, or PX_FIELD_TIMESTAMP.

	      o $format
		- String format similar to the format used by date(3). The placeholders support by this function is a subset of those supported by
		date(3) (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 #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)."
";

	      /* 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")."
";

	      px_delete($px);
	      ?>

	      The above example will output:

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

	The Julian day count as passed to jdtogregorian(3) 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.

SEE ALSO

       px_date2string(3), jdtogregorian(3).

PHP Documentation Group 												    PX_TIMESTAMP2STRING(3)

Check Out this Related Man Page

PX_RETRIEVE_RECORD(3)					     Library Functions Manual					     PX_RETRIEVE_RECORD(3)

NAME

       PX_retrieve_record -- Returns record in Paradox file

SYNOPSIS

       #include <paradox.h>

       pxval_t ** PX_retrieve_record(pxdoc_t *pxdoc, int recno)

DESCRIPTION

       Returns the record with the given number in a Paradox file. The first record has number 0, the last one has number_of_records-1.

       If you are accessing several records, do it in ascending order, because this is the most efficient way.

       The return value is an array of field values. Each value is stored in a structure like the following:

       typedef struct px_val pxval_t;
       struct px_val {
       char isnull;
       int type;
       union {
       long lval;
       double dval;
       struct {
       char *val;
       int len;
       } str;
       } value;
       };

       The  element  isnull  is  set  to  1 if the value is NULL otherwise it is set to 0. type 	       is the type of the paradox field as
       defined in paradox.h.  A field value can be either a long int, a double or a string, depending on the paradox field type. The paradox field
       types  pxfShort,  pxfLong,  pxfDate,  pxfTime,  pxfLogical,  and  pxfAutoInc are returned as long int values.  pxfTimestamp, pxfNumber, and
       pxfCurrency are returned as double values and all remaining paradox field types are stored as strings with the length in value.len. You can
       rely on strings being Null terminated. Blobs are stored as string but are not guarented to be Null terminated.

       The  paradox  field  types  pxfTimestamp,  pxfTime,  an	pxfDate  use an uncommon format which can be converted into a string with PX_time-
       stamp2string(3), PX_time2string(3), and PX_date2string(3).

RETURN VALUE

       Returns a pointer on success and NULL on failure.

SEE ALSO

       PX_update_record(3), PX_timestamp2string(3), PX_time2string(3), PX_date2string(3)

AUTHOR

       This manual page was written by Uwe Steinmann uwe@steinmann.cx.

															     PX_RETRIEVE_RECORD(3)

Linux and UNIX Man Pages

px_timestamp2string(3) [php man page]

Check Out this Related Man Page