Milliseconds to Date in Sun OS 5.10 Post: 303015068

Sponsored Content

Top Forums Shell Programming and Scripting Milliseconds to Date in Sun OS 5.10 Post 303015068 by Hozaifa on Tuesday 27th of March 2018 07:18:39 AM

03-27-2018

Registered User

Quote:

Originally Posted by Chubler_XL

You can try /usr/bin/adb like vgersh99 suggests (I'm not sure what format your date will appear in however) like this:

Code:

awk 'BEGIN {FS = ","}; NR>1 split($42,a,"|") {
TM=$3
sub(/[.].*$/,x,TM)
CMD="echo \"0t\" TM | /usr/bin/adb"
CMD  | getline tm
close (CMD)
print tm "," $46 "," $48 "," $47 "," null "," null "," a[2] "," $6 "," $49 "," $7 "," $8 ","}' ttt.csv > tttn.csv

or use perl like this:

Code:

awk 'BEGIN {FS = ","}; NR>1 split($42,a,"|") {
TM=$3
sub(/[.].*$/,x,TM)
CMD="perl -we '\''use POSIX ; print strftime(\"%m/%d/%Y %T\", localtime(" TM "))'\''"
CMD  | getline tm
close (CMD)
print tm "," $46 "," $48 "," $47 "," null "," null "," a[2] "," $6 "," $49 "," $7 "," $8 ","}' ttt.csv > tttn.csv

thanks for your reply but the first solution give the following error :
adb: syntax error on line 1 of (stdin) near "tm"

the second solution works but with very low performance

Could you please help me to enhance the performance or fix the fist solution error
note that I am using nawk because awk and gawk gives me errors too.

Hozaifa

View Public Profile for Hozaifa

Find all posts by Hozaifa

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

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. Shell Programming and Scripting

how to use sleep comand for milliseconds?

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

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

6. Solaris

Yesterday's date on Sun solaris

Can someone help me with the command to get yesterday's date on Sun solaris??

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

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

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'))", ...

LEARN ABOUT DEBIAN

ifpps

ifpps(8)							netsniff-ng-toolkit							  ifpps(8)

NAME

       ifpps - fetch and format kernel network statistics

SYNOPSIS

       ifpps	 -d|--dev <netdev> [-t|--interval <sec>][-p|--promisc][-c|--term]
	    [-C|--csv][-H|--csv-tablehead][-l|--loop][-v|--version][-h|--help]

DESCRIPTION

       A tiny tool to provide top-like reliable networking statistics.	ifpps reads out the 'real' kernel statistics, so it does not give
       erroneous statistics on high I/O load.

OPTIONS

       ifpps --dev eth0
	   Fetch eth0 interface statistics.

       ifpps --dev eth0 --interval 60 --csv
	   Output eth0 interface statistics every minute in CSV format.

OPTIONS

       -h|--help
	   Print help text and lists all options.

       -v|--version
	   Print version.

       -d|--dev <netdev>
	   Device to fetch statistics for i.e., eth0.

       -p|--promisc
	   Put the device in promiscuous mode

       -t|--interval <time>
	   Refresh time in sec (default 1 sec)

       -c|--term
	   Output to terminal

       -C|--csv
	   Output in CSV format.  E.g. post-processing with Gnuplot et al.

       -H|--csv-tablehead
	   Print CSV table head.

       -l|--loop
	   Loop terminal output.

AUTHOR

       Written by Daniel Borkmann <daniel@netsniff-ng.org>

DOCUMENTATION

       Documentation by Emmanuel Roullit <emmanuel@netsniff-ng.org>

BUGS

       Please report bugs to <bugs@netsniff-ng.org>

								    2012-06-29								  ifpps(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

useing date or other time style utility to get milliseconds.

Discussion started by: Optimus_P

2. Programming

C time in milliseconds function.

Discussion started by: kamil

3. Shell Programming and Scripting

how to use sleep comand for milliseconds?

Discussion started by: brkavi_in

4. Shell Programming and Scripting

Convert milliseconds to standard time

Discussion started by: chiru_h