Sponsored Content
Full Discussion: Local time to GMT time
Top Forums Shell Programming and Scripting Local time to GMT time Post 302991622 by RudiC on Tuesday 14th of February 2017 02:07:23 PM
Old 02-14-2017
Mayhap sth. along this line:
Code:
awk -vGPS0=$(TZ=UTC date -d'1/6/1980 0:00' +%s) '{print "@" int($NF/1E6)+GPS0}' CONVFMT="%.f" file | LC_ALL=C TZ=+3 date -f-
Sat Feb 11 21:00:23  2017
Sat Feb 11 21:00:26  2017
Sat Feb 11 22:55:50  2017
Sun Feb 12 04:37:07  2017

Quote:
Originally Posted by Corona688
.
.
.
What does 1170882025944002 represent, anyway?
That's the GPS date / time representation, starting at 6. Jan 1980, 0:00h UTC, in microseconds. Delta to *nix epoch is 315964800 sec.

Last edited by RudiC; 02-14-2017 at 03:21 PM..
This User Gave Thanks to RudiC For This Post:
 

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 (1 Reply)
Discussion started by: ssmiths001
1 Replies

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... (5 Replies)
Discussion started by: xejatt
5 Replies

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 (3 Replies)
Discussion started by: tomjones
3 Replies

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... (2 Replies)
Discussion started by: vilius
2 Replies

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... (2 Replies)
Discussion started by: ERahman
2 Replies

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... (2 Replies)
Discussion started by: forte712
2 Replies

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 (0 Replies)
Discussion started by: Neo
0 Replies

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 (13 Replies)
Discussion started by: mrn6430
13 Replies

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 |... (4 Replies)
Discussion started by: mrn6430
4 Replies
DB2_FIELD_SCALE(3)							 1							DB2_FIELD_SCALE(3)

db2_field_scale - Returns the scale of the indicated column in a result set

SYNOPSIS
int db2_field_scale (resource $stmt, mixed $column) DESCRIPTION
Returns the scale of the indicated column in a result set. PARAMETERS
o $stmt - Specifies a statement resource containing a result set. o $column - Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column. RETURN VALUES
Returns an integer containing the scale of the specified column. If the specified column does not exist in the result set, db2_field_scale(3) returns FALSE. SEE ALSO
db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_type(3), db2_field_width(3). PHP Documentation Group DB2_FIELD_SCALE(3)
All times are GMT -4. The time now is 09:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy