04-22-2006
find a date two weeks ago?
Anyone got a script or suggestion for this?
I want to find the date when a parameter in days is supplied..
ie.. parameter can be any number for example 15... and the date returned should then be 15 days ago... or 31 and the date returned should be 31 days ago...
Any ideas on best way to get this?
I am running solaris 9 and can install any commands if necessary.
I know GNU date utility can help me - but I cannot locate where to download this for solaris sparc....
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI,
I need to check whether the given file is 5 weeks older than current date ??
Can anyone give me the script for this ?? (1 Reply)
Discussion started by: risshanth
1 Replies
2. Shell Programming and Scripting
Hi,
Anybody knows how to get what date was 28 days ago of the current system date through UNIX script.
Ex : - If today is 28th Mar 2010 then I have to delete the files which arrived on 1st Mar 2010, (15 Replies)
Discussion started by: kandi.reddy
15 Replies
3. Shell Programming and Scripting
How could I using the following example, change it to show 2 days ago within the same time frame 0600 AM to 0600 AM
let foo=`date "+(1%H-106)*60+1%M-100"` bar=foo+1440
find . -mmin +$foo -mmin -$bar | tr -s '/','-' '^' | cut -f2,3 -d"^" | tr -s '^' ' ' |
Please use code tags (7 Replies)
Discussion started by: freddie999
7 Replies
4. Shell Programming and Scripting
Hi all,
I've used various scripts in the past to work out the date last week from the current date, however I now have a need to work out the date 1 week from a given date.
So for example, if I have a date of the 23rd July 2010, I would like a script that can work out that one week back was... (4 Replies)
Discussion started by: Donkey25
4 Replies
5. Shell Programming and Scripting
Hi
I have shell script and I am facing the below issue to integrate the date calculation to the the script.
If I give the $1 as the date(20110701) then I need to get the 7 days ago date for the same format.(20110624).
At first I thought its a simple one to handle and I did a search in the... (10 Replies)
Discussion started by: filter
10 Replies
6. Shell Programming and Scripting
I am unable to get the last week date i tried to use the following commands but i failed
Please help, and am using HP unix
date -d "+1 week"
date --date=yesterday +%y%m%d (5 Replies)
Discussion started by: jhon1257
5 Replies
7. Shell Programming and Scripting
I have written a script which generate one logfile on every sunday and thursday
I want to move the older log files into /tmp directory befor generating new one so i used mv command like
mv usr/sbin/appl/logfile.txt usr/sbin/appl/tmp
2) But when i move this file to /tmp it will... (1 Reply)
Discussion started by: Nakul_sh
1 Replies
8. UNIX for Beginners Questions & Answers
How to find a file that's modified more than 2 days ago but was modified less than 5 days ago by use of any Linux utility ? (4 Replies)
Discussion started by: abdulbadii
4 Replies
9. Shell Programming and Scripting
Hi all,
I have been researching to obtain SSL certification expiry for most of our webistes. For some cases, some hosts where not directly accessible so i finally got a solution working with curl using my proxy. This lists the expiry date which i'm finally looking for.
# curl --proxy... (4 Replies)
Discussion started by: nms
4 Replies
LEARN ABOUT PHP
px_insert_record
PX_INSERT_RECORD(3) PX_INSERT_RECORD(3)
px_insert_record - Inserts record into paradox database
SYNOPSIS
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)