04-21-2010
Date - String comparision
Hi,
I am having difficulty to compare a string in a file against a date from a a table and print the latest date. Below are the values.
String in File : 2009-12-02 00:37:51
Value Table : 2010-01-10-02.00.49.294758
I have to compare both the values ( Ignore the Microsecond in the table value) and select the most recent value.
Appreciate any help.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
I am trying to compare two dates which are in variables and i am not getting the correct result as expected.
$first_date = '07/19/2007'
$second_date='07/20/2007'
Can you please suggest how to i check whether they are equal or not.
if ($first_date -eq $second_date) condition is not... (3 Replies)
Discussion started by: kotasateesh
3 Replies
2. Solaris
I am wriitng a shell script to compare a date in `date +%Y%m%d%H%M` to the output of `cat /var/adm/messages.0 | grep Temp |grep "CPU Fans" | cut -f1-4,19 -d' '` which looks like
Dec 2 11:30:57 79
Dec 2 11:37:58 79
Dec 2 11:44:58 79
Dec 2 11:50:59 79
Dec 2 11:58:00 79
Dec 2... (1 Reply)
Discussion started by: Hitesh Shah
1 Replies
3. Shell Programming and Scripting
Hi All,
I have thefollowing files in the directory inbox/sat
ras.sat.trn.20090103.001902.00004358
ras.sat.trn.20090612.001903.00005339
ras.sat.trn.20090723.001902.00004358
The above file contains the date of the file creation. We just need to write a ksh shell script to check the... (5 Replies)
Discussion started by: satheesh_color
5 Replies
4. Shell Programming and Scripting
Hi,
I have a file which has the date in the last line in the example pasted along with the rates of the countries.
-- I want to compare the date in the last line of the file mentioned in the example below with the system date from Monday to Friday.
-- If system date is equal to the date... (2 Replies)
Discussion started by: Raji_gadam
2 Replies
5. Shell Programming and Scripting
#!/bin/ksh
var="2009-08-31 12:39:05 UTC"
ddate=`echo $var|cut -d' ' -f1`
y1=`echo $ddate|cut -d'-' -f1`
m1=`echo $ddate|cut -d'-' -f2`
d1=`echo $ddate|cut -d'-' -f3`
filedate=$y1$m1$d1
currdate="20070814"
if ]; then
echo "$LINE -> $filedate LOWER THAN $currdate"
... (0 Replies)
Discussion started by: HemaV
0 Replies
6. Programming
Hi,
I have written the following Pro*C program to get the difference between 2 dates.But when I am printing the value of the date difference,it is always showing 0.
#include<stdio.h>
#include<sqlca.h>
#include<oraca.h>
void main()
{
EXEC SQL BEGIN DECLARE SECTION;
int diff;
... (4 Replies)
Discussion started by: sureshbabuc
4 Replies
7. Shell Programming and Scripting
Hi All,
I want to generate quarter dates using awk or anything, by giving a dates as input
for example :
start_date=2010-01-01
end_date=2010-05-31
output should be:
start_date end_date qtr
2010-01-01 2010-03-31 1
2010-04-01 2010-05-31 2
Example 2:... (1 Reply)
Discussion started by: sol_nov
1 Replies
8. Shell Programming and Scripting
I have a string like ab or abc of whatever length. But i want to know whether another string ( for example, abcfghijkl, OR a<space> bcfghijkl ab<space> cfghijkl OR a<space>bcfghijkl OR ab<space> c<space> fghijkl ) starts with ab or abc... space might existing on the longer string... If so, i... (1 Reply)
Discussion started by: nram_krishna@ya
1 Replies
9. Shell Programming and Scripting
Hi All,
I would need your help to compare dates in my script.
Say if I have the dates in a file I need to comapre these dates with yesterday's date and the dates which are older than yesterday needs to be displayed.
Example:
03/22/2012
03/24/2012
03/20/2012
03/21/2012
03/12/2012... (1 Reply)
Discussion started by: pdreddy34
1 Replies
10. Shell Programming and Scripting
I have a script called " passwd_status " which gives the passwd-s status of my servers.
the script output is like below
password status for A:
abc ks 10/05/115 1 30 ps
password status for B:
abc ks 09/25/115 1 30 ps
password status for C:
abc ks 10/10/115 1 30 ps
Now , i want to... (1 Reply)
Discussion started by: charanarjun
1 Replies
LEARN ABOUT PHP
px_date2string
PX_DATE2STRING(3) PX_DATE2STRING(3)
px_date2string - Converts a date into a string.
SYNOPSIS
string px_date2string (resource $pxdoc, int $value, string $format)
DESCRIPTION
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 func-
tion is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the example below.
PARAMETERS
o $pxdoc
- Resource identifier of the paradox database as returned by px_new(3).
o $value
- Value as stored in paradox database field of type PX_FIELD_DATE.
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, L).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
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)."
";
/* px_date2string() outputs the same */
echo px_date2string($px, $days, "n/d/Y")."
";
px_delete($px);
?>
The above example will output:
7/15/1917
7/15/1917
SEE ALSO
px_timestamp2string(3), jdtogregorian(3).
PHP Documentation Group PX_DATE2STRING(3)