04-16-2008
script to convert epoch into human-readable
This is what I have to start out with
more file
1208217600
1208131200
1193806800
I want to convert the epoch column into a human-readable format. My file has hundreds of these epoch times that I want to loop through and convert. (The epoch time is really the last column of the line)
This is what I am trying
cat file |while read EPOCH
do
READABLE=`gawk 'BEGIN{print strftime("%c", $EPOCH )}'` # not working
READABLE=`gawk 'BEGIN{print strftime("%c",1144172897)}'` # works
echo $READABLE
done
why does the second line work when I hard code the epoch time in?
and the first line where I am reading in the variable not work?
reading about the syntax of the strftime
strftime([format [,timestamp]])
evidently timestamp has to be a number and not a variable
any ideas?
I don't have perl on this box but I do have nawk and awk and sed
Thanks
David
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
The following command provides the usage in 1024-byte blocks
du -ks * | sort -n | echo "$1"
...
1588820 user10
2463140 user11
2464096 user12
5808484 user13
6387400 user14
.....
I am trying to produce an output of first coulmn by multiplying by 1024 so that the output should... (11 Replies)
Discussion started by: ghazi
11 Replies
2. UNIX for Dummies Questions & Answers
$ quota
Disk quotas for user cqlouis (uid 1254):
Filesystem blocks quota limit grace files quota limit grace
/dev/sdb1 64 300000 320000 8 0 0
$
I want to make the output of command quota in human readable format? How to?
As we... (2 Replies)
Discussion started by: cqlouis
2 Replies
3. Shell Programming and Scripting
hay every body
i need script like bdf -h in hp-ux there is no option like solaris df -h
it is only bdf -k so i need the output with GBytes (8 Replies)
Discussion started by: maxim42
8 Replies
4. Shell Programming and Scripting
Hello
I have log file from solaris system which has date field converted by Java application using System.currentTimeMillis() function, example is 1280943608380 which equivalent to GMT: Wed, 04 Aug 2010 17:40:08 GMT.
Now I need a function in shell script which will convert 1280943608380... (3 Replies)
Discussion started by: Yaminib
3 Replies
5. UNIX for Dummies Questions & Answers
Is there any way to make netstat output the information in a more human readable format? even if it's not exact? I don't even care if it has to round up/down to the nearest Meg to make it work.
I wind up having to stare at netstat running for while and I wish I could get it to output things in a... (10 Replies)
Discussion started by: MrEddy
10 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I want to list all the directories present in a particular location and want to display their sizes as well. I know "ls -lh" but it doesn't show the size of the complete directory. So i want something like
dir1 266 MB
dir2 2 KB
dir3 22 MB
...
...
file1 10 Kb
.....
Thanks
Sarbjit (4 Replies)
Discussion started by: sarbjit
4 Replies
7. Shell Programming and Scripting
This does not work. One line works but my pattern are about 100 characters long and it is messy to read. When I try to use several lines it does not two'
find "$inputDirectory" \( -name 'very long pattern1'
-o -name 'very long pattern2'
-o -name... (1 Reply)
Discussion started by: Michael Stora
1 Replies
8. Shell Programming and Scripting
Hello Experts,
Below is the record i have:
sample data attached
I want this record of each row to be in single line and there are multiple rowise unixtime mentioned e.g 11996327 , This needs to be converted to Human readdable data and time from multiple rows
Can you help me , it will be... (10 Replies)
Discussion started by: manishK
10 Replies
9. Shell Programming and Scripting
Can someone help me to write a shell script to convert epoch timestamp into human readable format
1394553600,"test","79799776.0","19073982.728571","77547576.0","18835699.285714"
1394553600,"test1","80156064.0","19191275.014286","62475360.000000","14200554.720000"... (10 Replies)
Discussion started by: Moon1234
10 Replies
10. Programming
Scripting Language: bash shell script, python
I want to parse .nessus file in human readable format. If any one have any ideas please help me. (2 Replies)
Discussion started by: sk151993
2 Replies
LEARN ABOUT DEBIAN
function::ctime
function::ctime
FUNCTION:(3stap) Time utility functions FUNCTION:(3stap)
NAME
function::ctime - Convert seconds since epoch into human readable date/time string
SYNOPSIS
ctime:string(epochsecs:long)
ARGUMENTS
epochsecs
Number of seconds since epoch (as returned by gettimeofday_s)
DESCRIPTION
Takes an argument of seconds since the epoch as returned by gettimeofday_s. Returns a string of the form
"Wed Jun 30 21:49:08 1993"
The string will always be exactly 24 characters. If the time would be unreasonable far in the past (before what can be represented with a
32 bit offset in seconds from the epoch) the returned string will be "a long, long time ago...". If the time would be unreasonable far in
the future the returned string will be "far far in the future..." (both these strings are also 24 characters wide).
Note that the epoch (zero) corresponds to
"Thu Jan 1 00:00:00 1970"
The earliest full date given by ctime, corresponding to epochsecs -2147483648 is "Fri Dec 13 20:45:52 1901". The latest full date given by
ctime, corresponding to epochsecs 2147483647 is "Tue Jan 19 03:14:07 2038".
The abbreviations for the days of the week are 'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', and 'Sat'. The abbreviations for the months are
'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', and 'Dec'.
Note that the real C library ctime function puts a newline ('
') character at the end of the string that this function does not. Also note
that since the kernel has no concept of timezones, the returned time is always in GMT.
SystemTap Tapset Reference May 2013 FUNCTION:(3stap)