Convert Timestamp in text to Serial Date-Time


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert Timestamp in text to Serial Date-Time
# 15  
Old 02-16-2018
thanks for all the suggestions... will carry on working on it today and will let you know how i got on.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert Numeric Time to Readable Timestamp - Perl

I am trying to hit an URL using below command and get the data into an excel sheet. wget --user=<<USERID>> --pass=<<PASSWROD>> http://www.files.thatbelongstome.com/file1 -O test1.xls Next step is to consolidate files from 1 to 10 in a single excel sheet and send to my mail. I am working on... (1 Reply)
Discussion started by: PikK45
1 Replies

2. Shell Programming and Scripting

Convert date in dd mm yyyy format to UNIX timestamp

Hello All, I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following: date -d $mydate +%s where mydate = 23/12/2016 00:00:00 I am getting following error: date: extra operand `+%s' Try `date --help' for more information. ... (1 Reply)
Discussion started by: angshuman
1 Replies

3. AIX

convert a specific date to a unix timestamp

hello, i have an AIX5.3 machine and i am writing a script to display some processes. inside the script i want to get the time that the process starts and convert it to a unix timestamp. is there a command that i can use to do that? i search the web but all i found is long scripts and it does... (4 Replies)
Discussion started by: omonoiatis9
4 Replies

4. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

5. Shell Programming and Scripting

How to convert date and timestamp?

Hi, I have a file file1 having data as below 20110501,070742, ,012345678909,09999999999,68.5, 20110501,070236, ,089375855455,09376383333,374.3, 20110501,070525, ,090345895555,08444233444,206.2, 20110501,230051, ,000934744433,07624262223,480.1, First field is date(YYYYMMDD) and second... (5 Replies)
Discussion started by: vsachan
5 Replies

6. Shell Programming and Scripting

To convert a date(in string format) to unix timestamp

Hi All, I have a string like below. "Mar 31 2009" . I want to convert this to unix time . Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009". Thanks in advance,... (11 Replies)
Discussion started by: girish.raos
11 Replies

7. Shell Programming and Scripting

how to convert date time to epoch time in solaris

Hi, Is there any easy way to convert date time(stored in shell variable ) to epoch time in solaris box? As +%s is working on linux but not on solaris, also -d option is not working. Any suggestion please? (6 Replies)
Discussion started by: anshuman0507
6 Replies

8. Shell Programming and Scripting

Convert date to unix time

Hi, I need to convert a date in the format yyyy-mm-dd to unix seconds, shell script or perl would be ok since there is no hour/second, we can assume 12am every day thanks in advance funksen (4 Replies)
Discussion started by: funksen
4 Replies

9. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

10. Shell Programming and Scripting

how to convert from timestamp to date format in tcsh

hello all im looking for fast way to convert timestamp format to date format and vaiseversa in tcsh , can it be done? thanks allot (2 Replies)
Discussion started by: umen
2 Replies
Login or Register to Ask a Question
NTP(8)							      System Manager's Manual							    NTP(8)

NAME
ntp - query an ntp clock SYNOPSIS
ntp [-v] [-s] [-f] hosts... DESCRIPTION
ntp sends an ntp packet to the ntp daemon running on each of the given hosts. A daemon fills in fields of the ntp packet as per RFC-???? and sends the packet back. ntp then formats and prints the result on the standard output. The default output shows the delay, offset, and date in ctime() format. Options can reset the time of the local system clock. OPTIONS
-v Verbose output, showing the full contents of received ntp packets, plus caluclated offset, displacement, etc. -s Set system time-of-day clock. Will only happen if time offset is less than compiled-in constant WAYTOBIG (currently 1000 seconds). Will not happen if remote host is unsynchronized. -f Force setting system clock regardless of offset. Must be used with -s option. Still will not reset clock if remote system is unsynchronized. NTP RESULTS
The default output for each host looks like this: 128.8.10.1: delay:1.845207 offset:-0.358460 Mon Mar 20 08:05:44 1989 The verbose output for each host looks like this: Packet from: [128.8.10.1] Leap 0, version 1, mode Server, poll 6, precision -10 stratum 1 (WWVB) Synch Distance is 0000.1999 0.099991 Synch Dispersion is 0000.0000 0.000000 Reference Timestamp is a7bea6c3.88b40000 Tue Mar 7 14:06:43 1989 Originate Timestamp is a7bea6d7.d7e6e652 Tue Mar 7 14:07:03 1989 Receive Timestamp is a7bea6d7.cf1a0000 Tue Mar 7 14:07:03 1989 Transmit Timestamp is a7bea6d8.0ccc0000 Tue Mar 7 14:07:04 1989 Input Timestamp is a7bea6d8.1a77e5ea Tue Mar 7 14:07:04 1989 umd1: delay:0.019028 offset:-0.043890 Tue Mar 7 14:07:04 1989 The various fields are interpreted as follows: Packet from: [address] The address that this ntp packet was received from. Leap indicator: n The leap second indicator. Non-zero if there is to be a leap second added or subtracted at the new year. Status: n Stratum: n (source) The stratum of the clock in the NTP hierarchy, along with the source of the clock, either the name of a reference standard (such as WWVB or GOES) or the Internet address of the clock that this clock is derived from. Poll = n The desired poll rate of the peer. Precision = exponent (dec) The claimed precision of the clock, in seconds. Synchronizing Dist is ??? Synchronizing Dispersion is ??? The next five timestamps are given as NTP fixed-point values, in both hexadecimal and ctime(3). These are set either by this ntp process, or by the server we are quering. Reference Timestamp is hex-timestamp ctime string The last time the server clock was adjusted. (remote time) Originate Timestamp is hex-timestamp ctime string When the ntp request was transmitted by us to the server. (local time) Receive Timestamp is hex-timestamp ctime string When the ntp request was received at the server. (remote time) Transmit Timestamp is hex-timestamp ctime string When the ntp response was transmitted by the server. (remote time) Input Timestamp is hex-timestamp ctime string When the ntp response was received by us. (local time) hostname: delay:time offset:time The summary of the results of the query, giving the hostname of the responding clock (from the command line), the round-trip delay, and the offset between the two clocks (assuming symmetric round-trip times). BUGS
Using ntp with the current host will show inaccurate results. Probably a few others. Report bugs to Louis A. Mamokos (louie@trantor.umd.edu). SEE ALSO
RFC-???? Network Time Protocol(1), Dave Mills and ... ntpd(8), ntpdc(8) 30 July 1988 NTP(8)