Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: GMT to MST timestamp conversion
Top Forums Shell Programming and Scripting GMT to MST timestamp conversion Post 302928868 by kmanivan82 on Monday 15th of December 2014 07:55:56 PM
Old 12-15-2014
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)

Code:
#!/usr/bin/perl
use strict;
use warnings;
use Time::Local;

#always gmt
#my $tval = '2013-12-01T05:23:19.374';

my ($year,$month,$day,$hour,$min,$sec,$mil) = $ARGV[0] =~ m/^(\d{4})-(\d{1,2})-(\d{1,2})T(\d{1,2}):(\d{1,2}):(\d{1,2}).(\d{3})$/;
print "$year-$month-$day $hour:$min:$sec\n";
my $seconds = timelocal($sec, $min, $hour, $day, $month-1, $year);
($sec, $min, $hour,$day,$month, $year) = localtime($seconds-25200);

printf "%04d-%02d-%02d %02d:%02d:%02d", $year+1900, $month+1, $day, $hour, $min, $sec;

GMT is 7 hrs ahead of MST and 8 hrs ahead of MDT. Since we have hard coded 25200 the given timestamp is always converted to MST. Can someone help us to make it dynamic.. like.. during day light savings, the 8 hrs has to be deducted else 7 hrs.

Thanks
Krishnakanth
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

9. Shell Programming and Scripting

Timestamp conversion

Hello All, I have a file with many timestamps as in below format & example: 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... (4 Replies)
Discussion started by: ailnilanjan
4 Replies

10. Shell Programming and Scripting

GMT to local Time conversion

How can I convert the following date format: New Log Date = 2016-12-30 23:50:33 GMT from GMT time to local time? Thanks (13 Replies)
Discussion started by: mrn6430
13 Replies

LEARN ABOUT DEBIAN

gtk2::recentinfo

Gtk2::RecentInfo(3pm)					User Contributed Perl Documentation				     Gtk2::RecentInfo(3pm)

NAME

       Gtk2::RecentInfo - wrapper for GtkRecentInfo

HIERARCHY

	 Glib::Boxed
	 +----Gtk2::RecentInfo

METHODS

   timestamp = $info->get_added;
   timestamp = $info->get_modified;
   timestamp = $info->get_visited;
       cut

   integer = $info->get_age
   (exec, count, timestamp) = $info->get_application_info ($app_name)
       o   $app_name (string)

   (applications) = $info->get_applications
   string = $info->get_description
   string = $info->get_display_name
   boolean = $info->exists
   (groups) = $info->get_groups
   boolean = $info->has_application ($app_name)
       o   $app_name (string)

   boolean = $info->has_group ($group_name)
       o   $group_name (string)

   pixbuf = $info->get_icon ($size)
       o   $size (integer)

   boolean = $info->is_local
   string = $info->last_application
   boolean = $info->match ($other_info)
       o   $other_info (Gtk2::RecentInfo)

   string = $info->get_mime_type
   unix timestamp = $info->get_modified
   boolean = $info->get_private_hint
   string = $info->get_short_name
   string = $info->get_uri_display
   string = $info->get_uri
   unix timestamp = $info->get_visited
SEE ALSO

       Gtk2, Glib::Boxed

COPYRIGHT

       Copyright (C) 2003-2011 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.14.2							    2012-05-27						     Gtk2::RecentInfo(3pm)
All times are GMT -4. The time now is 05:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy