Sponsored Content
Full Discussion: How to Compare timestamp
Top Forums Shell Programming and Scripting How to Compare timestamp Post 302596381 by vsachan on Tuesday 7th of February 2012 08:36:17 AM
Old 02-07-2012
Question How to Compare timestamp

Hi,
my script is accepting the time from user. Then I have to select all records from file that lie between the time stamp supplied by user.

For eg
File format:
-----------
Code:
25-01-2012,20:06:27, ,09454545455,099999999999999,105,105, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:39, ,09454545455,099999999999999,994,994, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:39, ,094545455,099999999999999,88,88, , ,TTK32,9999, ,MUO2, ,O, ,99, , ,
25-01-2012,20:06:42, ,094545455,099999999999999,96,96, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:43, ,094545455,0999999999999,111,111, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:43, ,09455455,099999999999999,115,115, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:44, ,09454545455,099999999999999,83,83, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:51, ,09454545455,099999999999,114,114, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:52, ,094545455,099999999999999,161,161, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:52, ,09454545455,099999999999,96,96, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,
25-01-2012,20:06:53, ,09454545455,099999999999999,91,91, , ,TTK32,9999, ,PPUU, ,O, ,99, , ,


if The user is supplying
Code:
Time1=20:06:00
Time1=20:09:00

then we have to select all records whose time stamp is between these 2 times

Please suggest.

Last edited by Franklin52; 02-08-2012 at 06:10 AM.. Reason: Please use code tags for code and data samples, thank you
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to compare the timestamp of 2 files

i want to compare the timestamp of the 2 file.. please let me know how we can achive this.. (2 Replies)
Discussion started by: mail2sant
2 Replies

2. AIX

how to grep and compare timestamp in a file with the current date

I want to read a log file from a particular location.In the logfile , lines contains timestamp.I need to compare the timestamp in the logfile with the current date.If the timpestamp in the log file is less than 4 hours then i need to read the file from that location.Below is the file format.Please... (1 Reply)
Discussion started by: achu
1 Replies

3. AIX

how to grep and compare timestamp in a file with the current date

I want to read a log file from a particular location.In the log file each line starts with timestamp.I need to compare the timestamp in the logfile with the current date.If the timpestamp in the log file is less than 4 hours then i need to read the file from that location.Below is the file... (1 Reply)
Discussion started by: achu
1 Replies

4. Shell Programming and Scripting

Compare file timestamp with current date. Diff must be 1 hour.

Hello, I've created the script below to compare the content of two files with a delay of an hour. After an hour, the lines that exist in both files, will be printed and executed. The script now uses a counter to countdown 50 minutes. But what I would prefer is to check the file timestamp of... (3 Replies)
Discussion started by: taipan
3 Replies

5. Shell Programming and Scripting

Compare current time to timestamp on a file

I'm trying to compare 2 dates between current time and the timestamp on a file. The date format is mmdd Both return Apr 1 but when using if statement line 11: Apr 1: command not found error is returned #!/bin/sh log="DateLog" Current_Date=`date +%b%e` Filepmdate=`ls -l /file.txt |... (1 Reply)
Discussion started by: cillmor
1 Replies

6. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

7. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

8. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies

9. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

10. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies
PCAP_SET_TSTAMP_TYPE(3) 				     Library Functions Manual					   PCAP_SET_TSTAMP_TYPE(3)

NAME
pcap_set_tstamp_type - set the time stamp type to be used by a capture device SYNOPSIS
#include <pcap/pcap.h> int pcap_set_tstamp_type(pcap_t *p, int tstamp_type); DESCRIPTION
pcap_set_tstamp_type() sets the the type of time stamp desired for packets captured on the pcap descriptor to the type specified by tstamp_type. It must be called on a pcap descriptor created by pcap_create() that has not yet been activated by pcap_activate(). pcap_list_tstamp_types() will give a list of the time stamp types supported by a given capture device. See pcap-tstamp(7) for a list of all the time stamp types. RETURN VALUE
pcap_set_tstamp_type() returns 0 on success if the specified time stamp type is expected to be supported by the capture device, PCAP_WARN- ING_TSTAMP_TYPE_NOTSUP on success if the specified time stamp type is not supported by the capture device, PCAP_ERROR_ACTIVATED if called on a capture handle that has been activated, and PCAP_ERROR_CANTSET_TSTAMP_TYPE if the capture device doesn't support setting the time stamp type. SEE ALSO
pcap(3), pcap_list_tstamp_types(3), pcap_tstamp_type_name_to_val(3), pcap-tstamp(7) 21 August 2010 PCAP_SET_TSTAMP_TYPE(3)
All times are GMT -4. The time now is 12:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy