Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Timestamp conversion

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Timestamp conversion
# 1  
Old 02-02-2015
Timestamp conversion
Hello All,

I have a file with many timestamps as in below format & example:

Code:
20150130105120

2015-> Year in YYYY
01-> Month in MM
30-> Day in DD
10-> Hour in HH
51-> Minute in mm
20-> Seconds in SS

This is in GMT. I want to convert all these time stamps in GMT+5:30 format..

Can you please help me doing this?

This is Solaris10 box. GNU not installed..

BR
Nil

---------- Post updated at 04:29 PM ---------- Previous update was at 04:27 PM ----------

So the above example should look like below after example..
Code:
20150130162120

# 2  
Old 02-02-2015
The best way would probably be to:-
  • Convert this to seconds since the Epoch (197001010000 in the same format)
  • Add the required seconds to change the timezone
  • Convert back to your format.
Does this help?

You might (not sure on Solaris) be able to use the -s flag on date to get the time in seconds.

There are lots of threads on this site about date/time manipulation. have a search & read to see what you can find out.


Robin
This User Gave Thanks to rbatte1 For This Post:
ailnilanjan
# 3  
Old 02-02-2015
dont have
Code:
-s

to convert to epoc.. many restrictions!Smilie
# 4  
Old 02-02-2015
Solaris 5_10 comes with Perl 5.8 by default which has the Time::Local module by default.

This allows conversion to epoch
Code:
perl -MTime::Local -ne '
($y,$m,$d,$h,$M,$s)=$_=~/^(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/;
$time= timelocal($s,$M,$h,$d,$m -1 ,$y - 1900);
$time +=(5.5 * (60 * 60));
@time=localtime($time);
print "%04d%02d%02d%02d%02d%02d\n",$time[5]+1900,$time[4]+1,$time[3],$time[2],$time[1],$time[0];' $FILE_OF_JUST_TIMESTAMPS

This probably won't work directly for your situation, but could be used as the basis for a GMT<=>India log converter
This User Gave Thanks to Skrynesaver For This Post:
ailnilanjan
# 5  
Old 02-04-2015
Thanks.. That Idea helped!.. SmilieSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

GMT to MST timestamp conversion

Hi Team, We have written a perl script to perform the GMT to MST timestamp conversion. Input: 2013-12-01T05:23:19.374 Output: need the given timestamp in MT (MST/MDT) #!/usr/bin/perl use strict; use warnings; use Time::Local; #always gmt #my $tval = '2013-12-01T05:23:19.374'; ... (4 Replies)
Discussion started by: kmanivan82
4 Replies

2. 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

3. Shell Programming and Scripting

Timestamp conversion in PERL

Hi, I have a file as below I need to overwrite the 2 nd column alone to numeric format like "06122011030414012345" as per the timestamp value output file should be the microseconds can be neglected if required. Any help will be appreciated. Thanks in advance (1 Reply)
Discussion started by: irudayaraj
1 Replies

4. Shell Programming and Scripting

Epoch & Unix Timestamp Conversion Tools

Hi All, Please read the below data carefully. I need an unix command for converting unix timestamp to Epoch timestamp. I need to daily convert this today's unix(UTC) time to epoch time, so i am thinking to make a shellscript for this. Please help me for this by providing... (3 Replies)
Discussion started by: aish11
3 Replies

5. AIX

Need timestamp conversion shell script !!

Can anyone provide me with a ksh or bash script which will accept a timestamp (format is YYYY-MM-DD-HH24.Mi.Ss) and time offset (in hours). The output will be (timestamp passed - time offset passed deducted from it) in the same YYYY-MM-DD-HH24.Mi.Ss format. Basically I am trying to convert the... (1 Reply)
Discussion started by: shibajighosh
1 Replies

6. Programming

timestamp conversion problem.

Hi all. I have the following code: #include<stdio.h> #include<time.h> int main() { struct tm tm; time_t time = 1262322000; /*Jan, 01, 2010*/ char temp; int i = 0; while(i < 4) { memset(temp, 0, 128); localtime_r(&time,... (2 Replies)
Discussion started by: adm1n
2 Replies

7. Shell Programming and Scripting

[Perl] Timestamp conversion

Hi, I have searched, read and tried, but no luck. I have this code: #!/bin/perl -w #-d use strict; use POSIX qw(strftime); my $getprpw_list="/usr/lbin/getprpw -l"; my $host = "nbsol151"; my $user = "genadmin"; my %uid; my %spwchg; my %upwchg; my %slogint; (2 Replies)
Discussion started by: ejdv
2 Replies

8. Shell Programming and Scripting

conversion of different timestamp to standard timestamp

hi i need a scrit to convert one date format to another. for example i have three columns in a file which gets a different format, but lastly i want output with stadard timestamp as "yyyy-mm-dd hh:mm:ss" column1 column2 ... (2 Replies)
Discussion started by: dprakash
2 Replies

9. Shell Programming and Scripting

Timestamp to date conversion in ksh

Hi, I have a file containing timestamp( Example given below). How can i get date(mmd-dd-yyyy) from it? ($> cat file1.txt 2008-11-24 05:17:00.7043) Thanks, Sri (2 Replies)
Discussion started by: srilaxmi
2 Replies

10. Shell Programming and Scripting

conversion from EPOCH timestamp to local time zone

hello gurus, i want a perl/shell script which once invoked should convert a set of EPOCH timestamps to local time ( IST..i want) . how does it work ,i have an idea on that..but writing a perl/shell script for it is not possible for me...so i need help for the same. my exact requirement is... (2 Replies)
Discussion started by: abhijeetkul
2 Replies
Login or Register to Ask a Question