Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Milliseconds to Date in Sun OS 5.10
Top Forums Shell Programming and Scripting Milliseconds to Date in Sun OS 5.10 Post 303015025 by Hozaifa on Monday 26th of March 2018 01:25:53 PM
Old 03-26-2018
Milliseconds to Date in Sun OS 5.10
I am using Sun OS 5.10
I am Using nawk to extract specific column from csv file.
The third column of csv is the time in Milliseconds and I need to convert it to Date then save it in another csv file.

I am use this command to extract the columns I need and save it in tttn.csv

Code:
nawk 'BEGIN {FS = ","}; NR>1 split($42,a,"|") {print $3 "," $46 "," $48 "," 
$47 "," null "," null "," a[2] "," $6 "," $49 "," $7 "," $8 ","}' ttt.csv  > 
tttn.csv

What I should write to convert the third column $3 from milliseconds to Date
Here is on sample from the third column 1519208012.638884910 and I need to convert it to be in this format '02/21/2018 17:04:95'

How can I handle this task?
Last edited by vgersh99; 03-26-2018 at 02:32 PM.. Reason: code tags, please
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

useing date or other time style utility to get milliseconds.

hello everyone. im sure someone has run into the problem of timestamping files and end up haveing 2 files with the same name thus over writeing one of them. In my application i am trying to get a timestamp w/ milliseconds but i am haveing no luck and finding an answer in the man pages. I know... (3 Replies)
Discussion started by: Optimus_P
3 Replies

2. Programming

C time in milliseconds function.

I need a c function which return the time in: hour min sec and mil sec I am writing on unix os. (3 Replies)
Discussion started by: kamil
3 Replies

3. Shell Programming and Scripting

how to use sleep comand for milliseconds?

how to use sleep comand for milliseconds? (3 Replies)
Discussion started by: brkavi_in
3 Replies

4. Shell Programming and Scripting

Convert milliseconds to standard time

hello, I have the uptime of the server showing as upTime=2427742050 How do I convert it to standard time. Thanks Chiru (1 Reply)
Discussion started by: chiru_h
1 Replies

5. Shell Programming and Scripting

Getting Time in MilliSeconds with Perl

I use something like this in perl to get the date and time: use Time::localtime; use Time::gmtime; $tm = gmtime; $time_str = sprintf "%04d-%02d-%02d %02d:%02d:%02d", $tm->year + 1900, $tm->mon + 1, $tm->mday, $tm->hour, $tm->min, $tm->sec; It gives me something like this: 2010-08-26... (1 Reply)
Discussion started by: lforum
1 Replies

6. Solaris

Yesterday's date on Sun solaris

Can someone help me with the command to get yesterday's date on Sun solaris?? (1 Reply)
Discussion started by: sachinkl
1 Replies

7. Solaris

Process execution time in milliseconds

Hey everyone, I'm coming from Linux where the top command gave me lots of process info (particularly CPU time in milliseconds) and I'm trying to find similar info in Solaris. So far I've looked at prstat and ps but neither give cpu time in milliseconds, both seem to have 1 second... (2 Replies)
Discussion started by: maniac_ie
2 Replies

8. Shell Programming and Scripting

How do I do a short delay (milliseconds) in a shell script?

I need to put a small delay into a shell script. I'm looking for something smaller than "sleep" - a second is way too long. I want to sleep something like 10 milliseconds. I've tried "usleep" and "nanosleep", but the script doesn't recognize them. I'm using the bash shell but I'm willing to... (9 Replies)
Discussion started by: harmlesscat
9 Replies

9. UNIX for Dummies Questions & Answers

Date difference in Sun OS 5.10

Hi, I need to find the difference between 2 dates in SunOS 5.10 input will be in(yyyymmdd) date1: 20131011 date2:20131012 my output shold be diff between two dates i.e 0,1,2,3 date2 is always greater than date1. if it handles even leap year then it wil be more helpful. thank u... (2 Replies)
Discussion started by: mohanalakshmi
2 Replies

10. UNIX for Beginners Questions & Answers

Milliseconds Not Capture

while I load the value using sqlldr the millisecond values not stored in oracle table. Value: '26-OCT-17 08.59.50.916000000 AM' CTL field: SRC_SYS_CRT_TS Position(23:48) "decode(:SRC_SYS_CRT_TS,null,sysdate-1,to_timestamp(:SRC_SYS_CRT_TS,'yyyy-mm-dd.hh24.mi.ss.FF'))", ... (1 Reply)
Discussion started by: priya1987
1 Replies

LEARN ABOUT DEBIAN

bb-csvinfo.cgi

BB-CSVINFO.CGI(1)					      General Commands Manual						 BB-CSVINFO.CGI(1)

NAME

       bb-csvinfo.cgi - CGI program to show host information from a CSV file

SYNOPSIS

       bb-csvinfo.cgi

DESCRIPTION

       bb-csvinfo.cgi  is  invoked  as	a CGI script via the bb-csvinfo.sh CGI wrapper.  Based on the parameters it receives, it searches a comma-
       separated file for the matching host, and presents the information found as a table.

       bb-csvinfo.cgi is passed a QUERY_STRING environment variable with the following parameters:

	  key (string to search for, typically hostname)
	  column (columnnumber to search - default 0)
	  db  (name of the CSV database file in $BBHOME/etc/, default hostinfo.csv)
	  delimiter (delimiter character for columns, default semi-colon)

       CSV files are easily created from e.g. spreadsheets, by exporting them in CSV format. You should have one host per  line,  with	the  first
       line  containing  the  column headings. Despite their name, the default delimiter for CSV files is the semi-colon - if you need a different
       delimiter, invoke bb-csvinfo.cgi with the "delimiter=<character>" in the query string.

Example usage
       This example shows how you can use the bb-csvinfo CGI. It assumes you have a CSV-formatted file with information about the hosts stored	as
       $BBHOME/etc/hostinfo.csv, and the hostname is in the first column of the file.

       Use with the bbgen --docurl
	      The  --docurl  option to bbgen(1) sets up all of the hostnames on your Xymon webpages to act as links to a CGI script. To invoke the
	      bb-csvinfo CGI script, run bbgen with the option

		 --docurl=/cgi-bin/bb-csvinfo.sh?db=hostinfo.csv&key=%s

SEE ALSO

       bb-hosts(5), hobbitserver.cfg(5), bbgen(1)

Xymon							    Version 4.2.3:  4 Feb 2009						 BB-CSVINFO.CGI(1)
All times are GMT -4. The time now is 01:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy