12-26-2009
[PHP]Compare dates
Hi.
I have an application that stores some dates in unix timestamp format, and I need to compare those dates.
More exactly I need some sort of if-statements that checks how long time it is from todays date untill the timestamp and store it into variables.
When it's done, I need to have the output echoed so that I get an consecutive string like this:
John Doe, 10|Jane Doe, 5|
In the example above it shows both names and days left untill timestamp, I need to add more things too, it's just the comparing of the timestamps I need help with, as I have no clue of how to compare them and tell how many days there are between todays date and the timestamp.
It should be rounded down to the nearest lower day, so if there are 5.9 or 5.1 days left, it should only say 5 days.
Anyone who understand my need and can help me?
Many thanks in advance!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a log file with date format like
10-Oct-02 13:20:29 .....
at the beginning of each line in the log file, and I need to grep data from this file to list the lines with date no longer than one days.
I tried to use awk to do this but it looks very complicated to do it.
Is there... (6 Replies)
Discussion started by: wchen
6 Replies
2. Programming
Hi,
Is there any system defined function to compare two dates in C/C++?
Thanks (1 Reply)
Discussion started by: naan
1 Replies
3. Shell Programming and Scripting
Hi Gurus
I am getting the timestamp of the last generated log file
its like this "Oct 31 10:26"
I want to compare this timestamp with the current date in shell script. I want to compare if the
(timestamp-currentime) > 10 minutes
how do i do this.
Thanks
Ragha (2 Replies)
Discussion started by: ragha81
2 Replies
4. Shell Programming and Scripting
hi all :)
how can in compare yyyy/dd/mm with yyyy/dd/mm in perl i want the result like grater than or less than the given date...
thanks in advance (3 Replies)
Discussion started by: i_priyank
3 Replies
5. Shell Programming and Scripting
Hi all,
I've written a script which gives the below information...
End Date&Time: 2008-10-21 10.54.37
Now i want to calculate this time with the current time.. and if its more than 48 hours past with the current time it should echo "48 Hours back"
Please help me..
thanks in... (4 Replies)
Discussion started by: suri.tyson
4 Replies
6. Shell Programming and Scripting
Hi all,
How to check whether the given the two dates is minimal.
example:
Date 1 : 23-03-2008 with timestamp
Date 2: 20-03-2008 With tmestamp
I want to compare the twodates and which it gives the minimum date
i wnat to get the output like this below
output: the Date2 is... (1 Reply)
Discussion started by: balaji23_d
1 Replies
7. Shell Programming and Scripting
Need to find all records where date in one filed is greater than date in other.
Input:
ABC 2 Filed3 CDG * X 20080903 20081031 180.00
ABD 2 Filed3 CDG * X 20081101 20081031 190.00
ABE 2 Filed3 CDG * X 20090903 20081031 120.00
ABC 2 Filed3 CDG * X 20080903 20081015 130.00
Output:
... (2 Replies)
Discussion started by: necroman08
2 Replies
8. Shell Programming and Scripting
Hi to all.
When you have to compare a lot of dates in a SH code, there is a way to directly compare? For example, how can I check if two dates differ in less than a week?
Thank's for reading. (2 Replies)
Discussion started by: daniel.gbaena
2 Replies
9. HP-UX
Hi,
I want to convert two datetime fields to find out if the difference is one hour, in linux I've done this by converting both the datetime values to unix epoch time and subtracting them to find out if the difference is more than 3600s, however this does not work in hp-ux.
I've these... (3 Replies)
Discussion started by: Random_Net
3 Replies
10. Shell Programming and Scripting
Hi All,
I am entering StartDate and EndDate as parameters to script. Want to have an check saying, "If StartDate is greater than EndDate then don't execute the script".
Pseudo Code:
if
then
Execute script
else
exit 0
fi
Can you please help me on the same?
Thanks and... (4 Replies)
Discussion started by: Nagaraja Akkiva
4 Replies
LEARN ABOUT PHP
px_timestamp2string
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)