does anybody know how to find out the number of
days elapsed between 2 dates
e.g.
days elapsed between 020212 and 020110 (YYMMDD format)
Thanking you in advance.
Ravi. (1 Reply)
Hi All
How to get the difference between two dates in no of days ??? My date format is like this YYYY/MM/DD. I have to get the no of days between two dates in the given format.
I tried to search the forum but nothing came up similar to my requitement. Your help will be appreciated.
... (1 Reply)
Hi All,
Can unix cshell list out the number of days between 070201 and 070205 (format is yymmdd) and list out all the dates in between in similiar format.
set startdate = `date '+%y%m%d'` #eg 070201
set enddate = `date '+%y%m%d'` #eg 070205
i would expect the number of days to be 5... (2 Replies)
Hi
I'm looking for a .ksh script/function that will calculate ONLY the number of days between two distinct dates. Further convert the number of days to weeks and display. I need this to be part of another larger script that checks the password expiry on several servers and notifies the... (1 Reply)
Hello,
I would like to find out the number of days between two dates of the format yyyy-mm-dd.
Any help on this is highly appreciated.
Thanks. (6 Replies)
I have two times in the format of YYMMDD. Does anyone know an easy way in ksh for me to display how many days are between the two dates?
Example1:
X=101202
Y=101205
There are 3 days between X & Y
Example2:
X=101202
Y=111202
There are 365 days between X & Y
Example3:
X=101205... (3 Replies)
I wrote the day calculator also in bash. I would like to now, that is it good so?
#!/bin/bash
datum1=`date -d "1991/1/1" "+%s"`
datum2=`date "+%s"`
diff=$(($datum2-$datum1))
days=$(($diff/(60*60*24)))
echo $days
Thanks in advance for your help! (3 Replies)
Hi Am using Unix Ksh
I have a two date input as
DATE1=02/12/2012
DATE2=30/12/2012
I Need the output as only sunday date
02/12/2012
09/12/2012
16/12/2012
23/12/2012
30/12/2012
can anyone pls help me..
thanks in advance... (2 Replies)
Gents.
Please can u help.
I would like to calculate the days between two dates.
Example file1 ( previous date)
file1 - Input file
9/29/2010 10195
9/29/2010 1057
2/2/2016 10
2/2/2016 10169
2/2/2016 1057
2/3/2016 10005
2/3/2016 10014
In file2 I add the actual date using this code.... (9 Replies)
Discussion started by: jiam912
9 Replies
LEARN ABOUT PHP
px_insert_record
PX_INSERT_RECORD(3)PX_INSERT_RECORD(3)px_insert_record - Inserts record into paradox databaseSYNOPSIS
int px_insert_record (resource $pxdoc, array $data)
DESCRIPTION
Inserts a new record into the database. The record is not necessarily inserted at the end of the database, but may be inserted at any
position depending on where the first free slot is found.
The record data is passed as an array of field values. The elements in the array must correspond to the fields in the database. If the
array has less elements than fields in the database, the remaining fields will be set to null.
Most field values can be passed as its equivalent php type e.g. a long value is used for fields of type PX_FIELD_LONG, PX_FIELD_SHORT and
PX_FIELD_AUTOINC, a double values is used for fields of type PX_FIELD_CURRENCY and PX_FIELD_NUMBER. Field values for blob and alpha fields
are passed as strings.
Fields of type PX_FIELD_TIME and PX_FIELD_DATE both require a long value. In the first case this is the number of milliseconds since mid-
night. In the second case this is the number of days since 1.1.0000. Below there are two examples to convert the current date or timestamp
into a value suitable for one of paradox's date/time fields.
Note
This function is only available if pxlib >= 0.6.0 is used.
PARAMETERS
o $pxdoc
- Resource identifier of the paradox database as returned by px_new(3).
o $data
- Associated or indexed array containing the field values as e.g. returned by px_retrieve_record(3).
RETURN VALUES
Returns FALSE on failure or the record number in case of success.
EXAMPLES
Example #1
Set the date/time fields in a paradox database to the current date/time
<?php
$px = px_new();
$fp = fopen("test.db", "w+");
px_create_fp($px, $fp, array(array("timestamp", "@"), array("time", "T"), array("date", "D")));
$curdate = getdate();
$jd = gregoriantojd($curdate["mon"], $curdate["mday"], $curdate["year"]);
$days = $jd - 1721425; /* Number of days between 1.1.4714 b.c. and 1.1.0000 */
$secs = $curdate["hours"]*3600 + $curdate["minutes"]*60 + $curdate["seconds"];
px_insert_record($px, array($days*86400000.0 + $secs*1000.0, $secs*1000.0, $days));
$curtimestamp = microtime(true);
$days = (int) ($curtimestamp/86400);
$secs = $curtimestamp - ($days * 86400.0);
$days += 2440588; /* Number of days between 1.1.4714 b.c. and 1.1.1970 */
$days -= 1721425; /* Number of days between 1.1.4714 b.c. and 1.1.0000 */
px_insert_record($px, array($days*86400000.0 + $secs*1000.0, $secs*1000.0, $days));
for($i=0; $i<2; $i++) {
$rec = px_retrieve_record($px, $i);
echo px_timestamp2string($px, $rec["timestamp"], "n/d/Y H:i:s")."
";
echo px_date2string($px, $rec["date"], "n/d/Y")."
";
}
px_close($px);
px_delete($px);
?>
The above example will output:
2/21/2006 21:42:30
2/21/2006
2/21/2006 20:42:30
2/21/2006
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 milli seconds.
SEE ALSO px_update_record(3)PHP Documentation Group PX_INSERT_RECORD(3)