Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Date Range Problem

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date Range Problem
# 1  
Old 06-01-2010
Date Range Problem
Hi All,

I have a log file which has first few characters of every line as a timestamp.

Code:
2010-06-01 04:56:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 04:56:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 04:56:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 04:56:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 05:22:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 05:22:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 05:22:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 05:22:02,802 DEBUG {Thread-27}  Some text message
2010-06-01 06:43:02,802 INFO  {Thread-27}  Some text message
2010-06-01 06:43:02,803 INFO  {Thread-27}  Some text message
2010-06-01 06:43:02,804 INFO  {Thread-27}  Some text message
2010-06-01 06:43:02,804 INFO  {Thread-27}  Some text message
2010-06-01 06:43:02,809 DEBUG {Thread-27}  Some text message
2010-06-01 06:43:02,809 DEBUG {Thread-27}  Some text message
2010-06-01 06:43:02,809 DEBUG {Thread-27}  Some text message
2010-06-01 07:08:02,809 DEBUG {Thread-27}  Some text message
2010-06-01 07:08:02,809 DEBUG {Thread-27}  Some text message

My aim to find all such lines which have the timestamp of 1 hr before the current time.

How can this be achieved?

TIA,
Nitin.
# 2  
Old 06-01-2010
is your date is GNU date ?

provide the output of

Code:
uname -a

# 3  
Old 06-01-2010
Code:
Nitin--Bld-17:~ nitin$ uname -a
Darwin Nitin--Bld-17.local 9.7.0 Darwin Kernel Version 9.7.0: Tue Mar 31 22:52:17 PDT 2009; root:xnu-1228.12.14~1/RELEASE_I386 i386
Nitin--Bld-17:~ nitin$

# 4  
Old 06-01-2010
check whether this works for you

Code:
last_time=`tail -1 date_file | awk '{print $2}'`
one_hour_ago=`date -d "$last_time 1 hour ago" "+%Y-%m-%d %H:[0-5][0-9]"`

echo $last_time
echo $one_hour_ago

first_cut_point=`grep -n -m 1 "$one_hour_ago" date_file | awk -F":" '{print $1}'`
second_cut_point=`grep -n -m 1 "$last_time" date_file | awk -F":" '{print $1}'`

echo $first_cut_point
echo  $second_cut_point
sed -n ${first_cut_point},${second_cut_point}p date_file

# 5  
Old 06-01-2010
Getting an error. Dont know why Smilie
Code:
Nitin--Bld-17:UnixScriptTest nitin$ last_time=`tail -1 times.txt | awk '{print $2}'`
Nitin--Bld-17:UnixScriptTest nitin$ echo $last_time
12:31:34.0707
Nitin--Bld-17:UnixScriptTest nitin$ one_hour_ago=`date -d "$last_time 1 hour ago" "+%Y-%m-%d %H:[0-5][0-9]"`
usage: date [-jnu] [-d dst] [-r seconds] [-t west] [-v[+|-]val[ymwdHMS]] ... 
            [-f fmt date | [[[mm]dd]HH]MM[[cc]yy][.ss]] [+format]
Nitin--Bld-17:UnixScriptTest nitin$

# 6  
Old 06-01-2010
try to execute the below command..

Code:
date -d "1 hour ago"

if the above command is not executing successfully, then my script will not work. then you have to write a seperate logic to find out the one hour less time
This User Gave Thanks to itkamaraj For This Post:
nitin14341
# 7  
Old 06-01-2010
if you don't have GNU date, perhaps the below thread could help you.

date arithmetic

Also,
Various threads and FAQs about date arithmetic
This User Gave Thanks to clx For This Post:
nitin14341
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date range

Dear all, how can I select in the file below only the files created between Aug 14 2014 and Feb 03 2015? EZA2284I -rw-r--r-- 1 30 8 356954 Aug 15 2014 file1 EZA2284I -rw-rw-r-- 1 30 8 251396 Feb 05 12:53 file2 EZA2284I -rw-rw-r-- 1 30 8 ... (3 Replies)
Discussion started by: simomuc
3 Replies

2. UNIX for Dummies Questions & Answers

Find the count of files by last created date based on the given date range

My unix version is IBM AIX Version 6.1 I tried google my requirement and found the below answer, find . -newermt “2012-06-15 08:13" ! -newermt “2012-06-15 18:20" But newer command is not working in AIX version 6.1 unix I have given my requirement below: Input: atr files: ... (1 Reply)
Discussion started by: yuvaa27
1 Replies

3. UNIX for Dummies Questions & Answers

How can i get the date range for the last 4 days?

Hi i am try to run a script by using a dates here is what i am doing EXPORTDATE=`date --date "2 days ago" +%Y-%m-%d` sh /path/to/the/files.sh ${EXPORTDATE} the above code runs the job for one day,if i want to run the job for all the past 4 days how can i pass the date as a... (1 Reply)
Discussion started by: vikatakavi
1 Replies

4. Shell Programming and Scripting

Date listing in a date range

Solaris 10 ksh88 Sorry for re-hashing some of this, but I can't find a proper solution in the forums. Starting with /a/archive containing (on and on date formatted directories) 20060313 20080518 20100725 20121015 20060314 20080519 ... (1 Reply)
Discussion started by: moesplace
1 Replies

5. Shell Programming and Scripting

Date Range in UNIX

Hi Everyone How all are doing today, Want some help from All in Unix, What I am trying to do is , A shell file should be a called with two date parameters suppose the shell file name is run.sh run.sh <start_date> <end_date> If end date is not given it will pick today's date. The date should... (7 Replies)
Discussion started by: adisky123
7 Replies

6. Shell Programming and Scripting

Script on Date Range

Hi All, Can anybody help me out a Shell script which pulls the files based on date range Example ./test.sh start_date End_date (20110901 20110930) or ./test.sh ( if we don't provide any input) it should take sysdate-1 ( yesterdays date) it should have both conditions Plzz help me... (1 Reply)
Discussion started by: krux_rap
1 Replies

7. UNIX Desktop Questions & Answers

date range

I have a number of instances wher I need to run reports for the previous month and need to include the last months date range in the sql. I want to create a string which consists of the first and last dates of last month separated with an ' and ' ie for this month (Feb) I want it to say '01/01/10... (3 Replies)
Discussion started by: Niven
3 Replies

8. Shell Programming and Scripting

Date Range problem

Hi , I need a function that verfies the given date is between start date and end date . I have written this but this not working if start date is 1900/01/01 Below is my code validateDate() { RC=$# if then return 0 else ... (2 Replies)
Discussion started by: Satyak
2 Replies

9. Shell Programming and Scripting

Get date range between 2 date input

Hi Experts, I have files name report_20090416 report_20090417 report_20090418 report_20090420 report_20090421 I have 2 input from user From Date: 20090417 To Date: 20090420 and I need to grep only those line in between. Output should be report_20090417 report_20090418... (3 Replies)
Discussion started by: tanit
3 Replies

10. UNIX for Dummies Questions & Answers

cp only files in certain date range

hi all, I'm trying to do a cp only on files I created on a given day or within a certain date range. What's the best way to do this? Cheers, KL (1 Reply)
Discussion started by: ee7klt
1 Replies
Login or Register to Ask a Question