Sponsored Content
Top Forums Shell Programming and Scripting Adding time to date time in UNIX shell scipting Post 302737859 by codehelp04 on Friday 30th of November 2012 12:07:03 AM
Old 11-30-2012
Adding time to date time in UNIX shell scipting

I needed some help in adding a duration (in seconds) to a start time (in hhmmss format) and a start date (in mmddyy format) in order to get an end date and end time. The concept of a leap year is also to be considered while incrementing the day. The code/ function that I have formed so far is as follows, but there appears to be an error in the function calling. I also wanted to check if this script designed by me is full proof.

Code:
MIN_TIME = start_time; 
                        secs=substr(MIN_TIME,5,2);
            mins=substr(MIN_TIME,3,2);
            hrs=substr(MIN_TIME,1,2);
            durn=p;
            d=substr(MIN_DATE,3,2);
            m=substr(MIN_DATE,1,2);
            y=substr(MIN_DATE,5,2);
            date=d;
            mone=m;
            ye=y;
            durn=p;

 function incrementday (d, m, y)

      {  if(d<28)                                       #increment day
        { date=d+1;
        mone=m;
        ye=y;}

        else if(d == 28)
        { if(m==2)
            { if(y%4==0)
                {date=d+1; mone=m; ye=y;}
          else {date=1;
            mone=3;
                ye=y;}}
        else {date = d+1;
         mone=m;
         ye=y;}}
    
    else if(d==29)
    { if(m==2)
        {date=1;
         mone=03;
         ye=y;}
      else
          {date=d+1;
           mone=m;
           ye=y;}}

    else if(d==30)
    { if(m==1||m==3||m==5||m==7||m==8||m==10||m==12)
        {date=d+1;
        ye=y;
        mone=m;}
    else {date=01;
        mone=m+1;
        ye=y;}}

    else {if(m==12)
        {date=01;
        mone=01;
        ye=y+1;
        }
        else {date=01;
            mone=m+1; ye=y;
        }}  }                            #incremented day
          

                
                        sece=secs+durn;
                        
                        if ((sece>=60) && (sece<3600))  # greater than a minute but less than an hour
                          { mine=mins+sece/60;
                                if (mine>=60)
                                    {hre=hrs+1;
                                            if (hre>=24)
                                                {hre=hre-24;
                                                                                                incrementday($d $m $y); }
        
                                     mine=mine-60;}
                            sece=sece%60;}

                        else if ((sece>=3600) && (sece<86400))  #greater than an hour but less than a day
                          { mine=mins+sece/60;
                            if(mine>=60)
                               {hre=hrs+mine/60;
                                if(hre>=24)
                                    {hre=hre-24;
                                                               incrementday($d $m $y); }         
                                mine=mine%60;}
                            sece=sece%60;}

                        else if (sece>=86400)    #greater than a day
                          {mine=mins+sece/60;
                            if (mine>=60)
                                {hre=hrs+mine/60;
                                    {hre=hre-24;
                                                               incrementday($d $m $y);}
                                 mine=mine%60;
                           sece=sece%60;}

---------- Post updated 11-30-12 at 12:07 AM ---------- Previous update was 11-29-12 at 10:40 PM ----------

Let me just elaborate on the variables used in the above code:
Code:
MIN_TIME- start time (in hhmmss format)
MIN_DATE- start date (in mmddyy format)
durn- duration in seconds, 6digits (eg 373687 seconds or 000037 seconds)
d-start day  
m-start month
y-start year
date- end day
mone- end month
ye- end year
secs- starting seconds
mins- starting minutes
hrs- starting hours
sece- ending seconds
mine- ending minutes
hre- ending hours

I hope this information makes it easier to understand the code and help me out in correcting/improvising it.

Last edited by Franklin52; 11-30-2012 at 04:42 AM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

problem with displaying date and adding time

Hi, I have a log file with contents like 81.49.74.131 - - 81.49.74.131 - - 116.112.52.31 - - 116.112.52.31 - - I need an output like this 81.49.74.131 14/Sep/2008 Time duration: 00:06:00 116.112.52.31 15/Sep/2008 Time duration: 00:00:01 Please anyone suggest a script for this.... (1 Reply)
Discussion started by: FuncMx
1 Replies

2. UNIX for Dummies Questions & Answers

Adding date and time to a log file

Morning all Im hoping you can help me. We have a nice new oracle server :( and are needing to move some files around for EDI and BACS. The server runs windows but has an app called MKS toolkit installed which give unix commands. (Needed for the oracle stuff) I have had a go using dos commands... (2 Replies)
Discussion started by: ltodd2
2 Replies

3. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

4. UNIX for Dummies Questions & Answers

Adding Date & time stamps to filename

I need to edit the file name with date and time while writing the script. please help. (1 Reply)
Discussion started by: manish.s
1 Replies

5. Shell Programming and Scripting

Adding date and time to file name

Hi All, i wanted to add date and time to the file names in the same directory so lets say a file in the directory is test.txt then after running the shell script it should be test-15-11-2010.txt. So I used the following script which works, #!/bin/bash thetime=`date +%Y-%m-%d--%H:%M:%S`... (7 Replies)
Discussion started by: cc_at_work
7 Replies

6. UNIX for Dummies Questions & Answers

Converting string date time to unix time in AWK

I'd like to convert a date string in the form of sun aug 19 09:03:10 EDT 2012, to unixtime timestamp using awk. I tried This is how each line of the file looks like, different date and time in this format Sun Aug 19 08:33:45 EDT 2012, user1(108.6.217.236) all: test on the 17th ... (2 Replies)
Discussion started by: bkkid
2 Replies

7. UNIX for Dummies Questions & Answers

Adding hours and minutes to current date (Only to date not to time)

Hi, I want to add some hours and minutes to the current date. For example, if the current date is "July 16, 2012 15:20", i want to add 5 hours 30 minutes to "July 16, 2012 00:00" not to "July 16, 2012 15:20". Please help. Thanks! (4 Replies)
Discussion started by: manojgarg
4 Replies

8. Solaris

modifying date and time and time zone on solaris 5.10 with (redundant server) veritas

I have a cluster of two Solaris server (veritas cluster). one working and the other is standby I am going to change the date on them , and am looking for a secure solution as it is giving an important service. my opinion is that the active one doesn't need to be restarted (if I don't change the... (1 Reply)
Discussion started by: barry1946
1 Replies

9. Shell Programming and Scripting

Adding Seconds to UNIX/Epoch-Time

Hello All, I have a Perl script I'm writing where I ask the user to enter a "start time" for something. The "$start_time" will be in the format of: # The Time CLI Option Can be in the format of: --start-time="1day" --start-time="2hours" --start-time="45min" ... (1 Reply)
Discussion started by: mrm5102
1 Replies

10. Shell Programming and Scripting

Date time difference in UNIX shell script

There are 2 dates, Tue Oct 1 13:40:19 2013 Sun Sept 30 10:26:23 2013 I have multiple dates like the above one. How do I calculate the date time difference and display in another column in Shell script. Please help. (3 Replies)
Discussion started by: tanmoysays
3 Replies
All times are GMT -4. The time now is 07:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy