Local time to GMT time Post: 302991630

Sponsored Content

Top Forums Shell Programming and Scripting Local time to GMT time Post 302991630 by Chubler_XL on Tuesday 14th of February 2017 03:31:31 PM

02-14-2017

Moderator

jiam912, you seem to work with gpstime in your data files a fair bit. perhaps you would benefit from this GNU awk function strfgps() which operates like the strftime() function except with gpstime:

Code:

TZ=0 gawk '
function strfgps(fmt, gps) {
    gsub(/%f/, sprintf("%03d", gps % 1E6 / 1E3), fmt)
    return strftime(fmt, gps / 1E6 + 315964800)
}
{
  $2 = strfgps("%m/%d/%y", $NF)
  $3 = strfgps("%H:%M:%S.%f", $NF)
  print
}' OFS="\t" infile

I used gsub() to add support for the %f format => milliseconds as 3 digit number.

output:

Code:

4153152529951   02/11/17        21:00:22.980    951     2960    41531.0 52529.0 1170882022980002
4108153261942   02/11/17        21:00:25.944    942     2959    41081.0 53261.0 1170882025944002
41511523611660  02/11/17        22:55:50.180    1660    2959    41511.0 52361.0 1170888950180002
410675237398    02/12/17        04:37:06.980    98      2958    41067.0 52373.0 1170909426980002

Last edited by Chubler_XL; 02-14-2017 at 05:19 PM..

These 3 Users Gave Thanks to Chubler_XL For This Post:

Chubler_XL

View Public Profile for Chubler_XL

Find all posts by Chubler_XL

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Time using Time::Local

Can someone tell me how to get the current date and time in the follwoing format, using Time::Local? MM/DD/YYYY HH:MI:SS AM/PM

2. Shell Programming and Scripting

Script to convert GMT to Asia/Hong Kong time

hi friends, this is my first time with this type of script so please pardon my ignorance. i have this script in which a piece of code needs to be added which can have the Asia/Hong kong time as well. system date and format is GMT so no problem with GMT and even EST is covered..i have ato add new...

3. HP-UX

change time mode from BST to GMT

I want to know how to change the time zone from BST to GMT avoid the daylight savings in hp-ux

4. AIX

Convert UTC time to local time ?

Hello, Using AIX6.1 box. I have UTC time value and need to convert it to local time value - I mean time zone and DST should be taken into consideration. I hope it could be done using shell environment - I don't want to write a program. thanks Vilius ---------- Post updated at 02:30 PM...

5. Solaris

Enabling time service in local zones

Hi, Is it possible to enable the time service in local zones? E.g. erahmanz1% svcs -a | grep -i time STATE STIME FMRI disabled Sep_10 svc:/network/daytime:dgram disabled Sep_10 svc:/network/daytime:stream disabled Sep_10 svc:/network/time:dgram...

6. UNIX for Dummies Questions & Answers

UTC time and Local time

Hi, A few days ago I changed my CentOS box's timezone to -07:00. Now the date commands output look like this (run almost simultaneously, less than 1 second delay).. # date Mon Sep 5 20:23:40 PDT 2011 # date -u Tue Sep 6 03:24:05 UTC 2011 The hours difference seems correct, but why is...

7. Post Here to Contact Site Administrators and Moderators

Server Upgrade Scheduled for Today - 7:30 GMT (2:30 PM Eastern Time)

Dear All, Today, somewhere around 7:30 GMT (2:30 PM Eastern Time) www.unix.com will go down for what we hope is around 15 - 20 minutes as we change out some hardware on the server. Thank you for your patience and support. Neo

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

9. Solaris

Convert GMT date and time to CST

I need away to convert the following GMT date and time value RAW_TME= 042720171530 "mmddccyyhhmm" to Localhost time. In this case it is in central time. Here is what I came up with but it does not look efficient: RAW_TME=042720171530 logmm=`echo $RAW_TME | cut -c1-2` logdd=`echo $RAW_TME |...

LEARN ABOUT MOJAVE

git-column

GIT-COLUMN(1)                                                       Git Manual                                                       GIT-COLUMN(1)

NAME

       git-column - Display data in columns

SYNOPSIS

       git column [--command=<name>] [--[raw-]mode=<mode>] [--width=<width>]
                    [--indent=<string>] [--nl=<string>] [--padding=<n>]

DESCRIPTION

       This command formats its input into multiple columns.

OPTIONS

       --command=<name>
           Look up layout mode using configuration variable column.<name> and column.ui.

       --mode=<mode>
           Specify layout mode. See configuration variable column.ui for option syntax.

       --raw-mode=<n>
           Same as --mode but take mode encoded as a number. This is mainly used by other commands that have already parsed layout mode.

       --width=<width>
           Specify the terminal width. By default git column will detect the terminal width, or fall back to 80 if it is unable to do so.

       --indent=<string>
           String to be printed at the beginning of each line.

       --nl=<N>
           String to be printed at the end of each line, including newline character.

       --padding=<N>
           The number of spaces between columns. One space by default.

GIT

       Part of the git(1) suite

Git 2.17.1                                                          10/05/2018                                                       GIT-COLUMN(1)