06-06-2010
Date Manipulation and Comparision
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:
start_date=2010-01-01
end_date=2010-06-30
output should be:
start_date end_date qtr
2010-01-01 2010-03-31 1
2010-04-01 2010-06-30 2
Thanks in advance...
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,
I'm comparing my file date with the system date and if both the dates are equal I'm doing some operation. I use two variables for these two dates. I use the following command in my query. if ....
But here the current date $cd shows 01 and filedate $fdate shows 1. The file is created on 1 of ... (6 Replies)
Discussion started by: pstanand
6 Replies
4. 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
5. 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
6. 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
7. 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
8. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: sam_78_nyc
5 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 LINUX
date::parse
Date::Parse(3pm) User Contributed Perl Documentation Date::Parse(3pm)
NAME
Date::Parse - Parse date strings into time values
SYNOPSIS
use Date::Parse;
$time = str2time($date);
($ss,$mm,$hh,$day,$month,$year,$zone) = strptime($date);
DESCRIPTION
"Date::Parse" provides two routines for parsing date strings into time values.
str2time(DATE [, ZONE])
"str2time" parses "DATE" and returns a unix time value, or undef upon failure. "ZONE", if given, specifies the timezone to assume when
parsing if the date string does not specify a timezone.
strptime(DATE [, ZONE])
"strptime" takes the same arguments as str2time but returns an array of values "($ss,$mm,$hh,$day,$month,$year,$zone)". Elements are
only defined if they could be extracted from the date string. The $zone element is the timezone offset in seconds from GMT. An empty
array is returned upon failure.
MULTI-LANGUAGE SUPPORT
Date::Parse is capable of parsing dates in several languages, these include English, French, German and Italian.
$lang = Date::Language->new('German');
$lang->str2time("25 Jun 1996 21:09:55 +0100");
EXAMPLE DATES
Below is a sample list of dates that are known to be parsable with Date::Parse
1995:01:24T09:08:17.1823213 ISO-8601
1995-01-24T09:08:17.1823213
Wed, 16 Jun 94 07:29:35 CST Comma and day name are optional
Thu, 13 Oct 94 10:13:13 -0700
Wed, 9 Nov 1994 09:50:32 -0500 (EST) Text in ()'s will be ignored.
21 dec 17:05 Will be parsed in the current time zone
21-dec 17:05
21/dec 17:05
21/dec/93 17:05
1999 10:02:18 "GMT"
16 Nov 94 22:28:20 PST
LIMITATION
Date::Parse uses Time::Local internally, so is limited to only parsing dates which result in valid values for Time::Local::timelocal. This
generally means dates between 1901-12-17 00:00:00 GMT and 2038-01-16 23:59:59 GMT
BUGS
When both the month and the date are specified in the date as numbers they are always parsed assuming that the month number comes before
the date. This is the usual format used in American dates.
The reason why it is like this and not dynamic is that it must be deterministic. Several people have suggested using the current locale,
but this will not work as the date being parsed may not be in the format of the current locale.
My plans to address this, which will be in a future release, is to allow the programmer to state what order they want these values parsed
in.
AUTHOR
Graham Barr <gbarr@pobox.com>
COPYRIGHT
Copyright (c) 1995-2009 Graham Barr. This program is free software; you can redistribute it and/or modify it under the same terms as Perl
itself.
perl v5.10.1 2010-07-28 Date::Parse(3pm)