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 FREEBSD

xo_message_c

LIBXO(3)						   BSD Library Functions Manual 						  LIBXO(3)

NAME

     xo_err -- emit errors and warnings in multiple formats

LIBRARY

     library ``libxo''

SYNOPSIS

     #include <libxo/xo.h>

     void
     xo_warn(const char *fmt, ...);

     void
     xo_warnx(const char *fmt, ...);

     void
     xo_warn_c(int code, const char *fmt, ...);

     void
     xo_warn_hc(xo_handle_t *xop, int code, const char *fmt, ...);

     void
     xo_err(int eval, const char *fmt, ...);

     void
     xo_errc(int eval, int code, const char *fmt, ...);

     void
     xo_errx(int eval, const char *fmt, ...);

     void
     xo_message(const char *fmt, ...);

     void
     xo_message_c(int code, const char *fmt, ...);

     void
     xo_message_hc(xo_handle_t *xop, int code, const char *fmt, ...);

     void
     xo_message_hcv(xo_handle_t *xop, int code, const char *fmt, va_list vap);

DESCRIPTION

     Many programs make use of the standard library functions err(3) and warn(3) to generate errors and warnings for the user.	libxo wants to
     pass that information via the current output style, and provides compatible functions to allow this.

     These functions display the program name, a colon, a formatted message based on the arguments, and then optionally a colon and an error mes-
     sage associated with either errno or the code parameter.

	       EXAMPLE:
		   if (open(filename, O_RDONLY) < 0)
		       xo_err(1, "cannot open file '%s'", filename);

ADDITIONAL DOCUMENTATION

     Complete documentation can be found on github:

	   http://juniper.github.io/libxo/libxo-manual.html

     libxo lives on github as:

	   https://github.com/Juniper/libxo

     The latest release of libxo is available at:

	   https://github.com/Juniper/libxo/releases

SEE ALSO

     xo_emit(3)

HISTORY

     The libxo library was added in FreeBSD 11.0.

AUTHOR

     Phil Shafer

BSD
								 December 4, 2014							       BSD