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 303015091 by Chubler_XL on Tuesday 27th of March 2018 03:47:52 PM
Old 03-27-2018
Oh so you have gawk on your system then.

Give this a go:

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

 

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

py_xls2csv

py_xls2csv(1)						      General Commands Manual						     py_xls2csv(1)

NAME

       py_xls2csv - convert an Excel xls file to a comma separated value csv file

SYNOPSIS

       py_xls2csv  input-file

DESCRIPTION

       This manual page was written for the Debian distribution because the original program does not have a manual page.

       py_xls2csv takes an Excel xls file as an argument and converts it to a comma separated value csv file.  Output is sent to stdout.

       Additional utility scripts can be found in the tools/ directory.

OPTIONS

       This program does not take any command line options.

AUTHOR

       pyexcelerator and py_xls2csv were written by Roman V. Kiseliov <roman@kiseliov.ru>.

       This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others).  Permission is granted
       to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any  later	version  published
       by the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

SEE-ALSO
       pyexcelerator(1), py_xls2txt(1), py_xls2html(1)

								 October 12, 2006						     py_xls2csv(1)
All times are GMT -4. The time now is 07:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy