To get the time exactly 24hrs from the current time


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting To get the time exactly 24hrs from the current time
# 1  
Old 07-06-2013
To get the time exactly 24hrs from the current time

Hi guys,

I am having file which contains below data.
Code:
2012-04-24 08:40:13     10739022730     1027699274PersonInfoShipTO details missing      FirstName,LastName,
2012-04-24 08:40:13     10739022730     1027699274PersonInfoShipTO details missing      FirstName,LastName,
2012-04-24 08:40:13     10739022730     1027699274PersonInfoShipTO details missing      FirstName,LastName,
2012-04-24 08:40:13     10739022730     1027699274PersonInfoShipTO details missing      FirstName,LastName,
2012-04-24 08:40:13     10739022730     1027699274PersonInfoShipTO details missing      FirstName,LastName,
2012-07-05 07:40:13     10739022730     1027699274PersonInfoShipTO details missing      FirstName,LastName,
2012-07-05 11:40:13     10739022730     1027699274PersonInfoShipTO detailsmissing      FirstName,LastName,
2013-07-05 08:40:13     10739022730     1027699274PersonInfoShipTO detailsmissing      FirstName,LastName,

First column represent the time stamp .My requirement is whenever i run my script it needs to go through the above file and should grep the line in which the time stamp should be between current time and 24hrs.
i.e
If i run the script by July 6 ,2013 10.00 pm ct then output should contains the date from July 5 ,2013 10.00 pm ct to July 6,2013 10.00 pm CT.
My OS version is
Code:
SunOS

Thank u guys.

Last edited by mohanalakshmi; 07-16-2013 at 10:00 AM.. Reason: wrong information
# 2  
Old 07-06-2013
You will need to use C or perl or or ruby -- some language. bash, ksh, nawk and other standard utilities that come with Solaris do not "do dates" like the GNU coretuils do.
So if someone posts an example using "date" or "awk" it will not work unless you have the GNU coreutils installed.

Here is a C example, someone else may post a perl example.
Code:
// tsrch.c
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <time.h>
//compile [g]cc -o tsrch tsrch.c
// usage ./tsrch < filename_to_search  NOTE the "<"

time_t then(const char *tmp)
{
    char *fmt="%Y-%m-%d %H:%M:%S ";
    struct tm tm;
    if(strptime(tmp, fmt, &tm)==NULL) // bad text in line
       return (time_t)0;
    
    return (time_t) mktime(&tm);
}

int main()
{
   time_t now=time(NULL);
   char tmp[1024]={0x0};
   while( fgets(tmp, sizeof(tmp), stdin)!=NULL )
   {    
      if(strlen(tmp)> 24 && 
         now - then(tmp) <=86400)  // seconds in 24 hours
      printf("%s", tmp);   
   }
   
   return 0;
}

/usr/sfw/bin/gcc (C compiler) is part of the standard Solaris 10 && 11 install
# 3  
Old 07-07-2013
Since your date format is sortable you could calculate the 24hour time using perl and then use a simple nawk script like this:

24hr.pl
Code:
#!/bin/perl
use POSIX; print strftime('%Y-%m-%d %H:%M:%S', localtime(time() - 24*60*60));

Then use this (24hr.pl executable and in current directory):
Code:
FROM=`./24hr.pl`
awk "\$0 > \"$FROM\"" infile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert UTC time into current UNIX sever time zone

Hi guys thanks for the help for my previous posts.Now i have a requirement that i download a XMl file which has UTC time stamp.I need to convert UTC time into Unix server timezone. For ex if the time zone of unix server is CDT then i need to convert into CDT.whatever may be the system time... (5 Replies)
Discussion started by: mohanalakshmi
5 Replies

2. Shell Programming and Scripting

Add current date and time

i have file 1.txt asdas|csada|13|03|10|04|23|A1|canberra sdasd|sfdsf|13|04|26|23|28|A1|sydney i want to add today's date and time in the end of each row expected output asdas|csada|13|03|10|04|23|A1|canberra|130430|1358 sdasd|sfdsf|13|04|26|23|28|A1|sydney|130430|1358 todays date... (10 Replies)
Discussion started by: radius
10 Replies

3. Shell Programming and Scripting

Displaying current date time of EDT in IST time

Hi Folks, My server time is in EDT. And i am sending automated mails from that server in which i need to display the current date time as per IST (GMT+5:30). Please advice how to display the date time as per IST. IST time leads 9:30 mins to EDT. and i wrote something like below. ... (6 Replies)
Discussion started by: Showdown
6 Replies

4. UNIX for Dummies Questions & Answers

Change time with current year

Hi, How can i change the time below (red font) with the current year? Thank You in advance. hostname 2007-Feb-9 /u100/DEVCO/Patching a.log hostname 2010-Jun-25 /u100/DEVCO/DumpCleaner a.log hostname 2011-Jun-25 /u100/DEVCO/DumpCleaner/sample a.log hostname 23:44-Jun-25... (2 Replies)
Discussion started by: lienyca
2 Replies

5. Shell Programming and Scripting

How far is given date from current time?

give a date and time: Jun 12 21:05:16 06-12-2012 21:05:16 2012/06/12 21:05:16 How can i subtract these dates and times from the current date and time and get back the difference in seconds? a one liner like: echo "Jun 12 21:05:16" | some perl/awk programming 90900s (2 Replies)
Discussion started by: SkySmart
2 Replies

6. AIX

crontab 1 hour off from current time

This is a new one on me. We upgraded a system from AIX 5.3 TL 7 to 6.1 TL 7 yesterday. The app people notified us that their cron jobs weren't running at the right time. So I made a test cron entry and here's what I've found: # crontab -l * * * * * /usr/bin/date > /tmp/test.log 2>&1 # cat... (2 Replies)
Discussion started by: homeyjoe
2 Replies

7. UNIX for Dummies Questions & Answers

getting the current time in Epoch format

Hi everybody, I want to get the current time in epoch format (in UNIX or Korn Shell) and store it in a variable called currentTime. Any response will be highly appreciated:) Thanks in advance, omoyne:D (8 Replies)
Discussion started by: omoyne
8 Replies

8. Shell Programming and Scripting

Getting current time from wolfram.com using python

Hello to all, I am looking of a python script that can fetch date & time from wolfram or any website that gives correct time. 1. Open woflram.com website 2. Search query "time" 3. Search result displays the time. The script has to contact the website with the search query, take that... (5 Replies)
Discussion started by: frozensmilz
5 Replies

9. Shell Programming and Scripting

getting hour minus the current time

Can some one help me getting last hour of the current time with date command in a script. (7 Replies)
Discussion started by: shehzad_m
7 Replies

10. Shell Programming and Scripting

Substituting variable with current time

Hi all I have a script as follows :- #!/usr/bin/ksh IDT=`date +"%OH%M%S"` while true do echo ${IDT} sleep 1 done I need the time to show me the current runtime value for the time, however this returns the time as at the start of the script. Any ideas. Thanks JH (4 Replies)
Discussion started by: jhansrod
4 Replies
Login or Register to Ask a Question