How to compare datetime?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to compare datetime?
# 8  
Old 07-11-2012
There is still no example from config and log file that can be brought to relation so it would make easier to understand. Maybe you fix that.
Anyway, assuming this line from your config:
Code:
Rockport        PDWRCK01        PDWRCK03        22:00

Rockport is the application name, PDWRCK01 the starting job, PDWRCK03 the ending job, and 22:00 the estimated starting time.
So 1 job has 2 different names for a starting entry and for an ending entry? Is that always like that?
Despite your explanation from the config file I assume from the logs, that there is 1 jobname and for it there is a "JOBINIT" entry and a "JOBTERM" to mark the end or is that wrong? Or does it really change it's jobname for the start and the end entry and you can only know what belongs together by your config?
So what you need is the "JOBINIT" string from the log, for the particular entry in your config and compare the date from the config with the date from the log, correct?
# 9  
Old 07-13-2012
Hi,
Sorry for the delay in replying.
Yes, There will be many jobs in a application , and I am placing the first job and the last job of the application in my config file. The time mentioned in the config file is the usual start time.
So, from the log I am trying to fetch the start time of the first job and end time of the last job(Jobterm). There will be an entry in the log only when the job completes. So for every entry, Jobinit and jobterm will be there.
Now my main problem is , I need to check if the times are for the current day or not.
Suppose if the time from the log is 07/10/2012 13.00.00 and I am looking for the date 07/11/2012, then it means that the job has not yet started for the day and the status should be shown as Not-started. For this I need to do date subtraction.

Thanks
Ajay
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Filename with datetime

Hello All, I need unix command to generate a file with datetime in it. For example : ABC_YYYYMMDDHH24MISS.txt Regards Biswajeet Ghosh (1 Reply)
Discussion started by: bghosh
1 Replies

2. Shell Programming and Scripting

SunOS compare datetime

Hi i need to compare the datetime between 2 columns. SunOS 5.1 is used. Notice that mktime seems like not supported. cat file2 P1,2012 12 4 21 36 48,2012 12 4 22 26 53 P2,2012 12 4 20 36 48,2012 12 4 21 21 23 P3,2012 12 4 18 36 48,2012 12 4 20 12 35 Below is the command used.... (1 Reply)
Discussion started by: chailee
1 Replies

3. UNIX for Dummies Questions & Answers

Find files between two datetime..

Hi All, How do i find all the files between two times. Eg: 26 may 2014 06:00 to 26 may 2014 14:00 mmin and mtime gives for a specific period. we receive hundreds of files input directories and i need to find how many files are received between given specific datetime. Thanks. (2 Replies)
Discussion started by: abhi_123
2 Replies

4. Shell Programming and Scripting

Adding 48 hours to DateTime

Hey Guys, I have looked for a solution throughout the forum for my particular question, but I cant find one. So I'm sorry if I overlooked it. I need to be able to 48 add hours to a particular DateTime string. I have a variable named $startTime I would like to be able to take that... (1 Reply)
Discussion started by: chagan02
1 Replies

5. Shell Programming and Scripting

How to generate datetime string?

Hi. I'm hoping there is a simple method where I'm able to generate a datetime string that looks like this (yyyymmddhhmm): 201106280830 The tricky part would be that I need this string to be today's datetime minus 1 year. Is there anyway to do this? (3 Replies)
Discussion started by: buechler66
3 Replies

6. Shell Programming and Scripting

datetime difference in seconds

Hi, I'm trying to find processing time of my script. Please can someone give me the commands to get the start/end time in "dd-mm-yyyy hh:mm:ss" and the differnce in seconds. Thanks! (5 Replies)
Discussion started by: dvah
5 Replies

7. Programming

SQL datetime calculation

Suppose I have a mysql table consisting of measurements taken during irregular intervals as follows: CREATE TABLE data (datetime DATETIME, value INTEGER); mysql> SELECT datetime, value FROM data; +---------------------+---------+ | datetime | value |... (2 Replies)
Discussion started by: figaro
2 Replies

8. Shell Programming and Scripting

Awk new datetime everyline

Hi, I'm using awk in HP-UX machine which does not support systime(), strftime(). So to get the date time I was using : seq 1 100000 | awk ' "date +%Y%m%d%H%M%s" | getline curtime; print curtime }' However the above code gets the date only once, next time it is not updated. For... (2 Replies)
Discussion started by: Random_Net
2 Replies

9. Shell Programming and Scripting

datetime.pm

Hi, I'm trying to use datetime.pm function in Perl. I do not have in the library. Is there a way to get it and put it into library? Thanks, George. (1 Reply)
Discussion started by: gpaulose
1 Replies
Login or Register to Ask a Question