Help on awk strftime

Shell Programming and Scripting
1

cat file

41285.000034722223 41285.000567129631
41285.000069444446 41285.001122685186
41285.000092592592 41285.001620370371
41285.000138888892 41285.00340277778
41285.000185185185 41285.000405092593
41285.000196759262 41285.000856481478
41285.000208333331 41285.000717592593
41285.000300925924 41285.001319444447
41285.000451388885 41285.000590277778
41285.000486111108 41285.002430555556
41285.000532407408 41285.000902777778
41285.000567129631 41285.00099537037
41285.000659722224 41285.001608796294
41285.000763888886 41285.001319444447
41285.000775462962 41285.000856481478
41285.000787037039 41285.001469907409

it should be

1/11/13 12:00 AM    1/11/13 12:00 AM
1/11/13 12:00 AM    1/11/13 12:01 AM
1/11/13 12:00 AM    1/11/13 12:02 AM
1/11/13 12:00 AM    1/11/13 12:04 AM
1/11/13 12:00 AM    1/11/13 12:00 AM
1/11/13 12:00 AM    1/11/13 12:01 AM
1/11/13 12:00 AM    1/11/13 12:01 AM
1/11/13 12:00 AM    1/11/13 12:01 AM
1/11/13 12:00 AM    1/11/13 12:00 AM
1/11/13 12:00 AM    1/11/13 12:03 AM
1/11/13 12:00 AM    1/11/13 12:01 AM
1/11/13 12:00 AM    1/11/13 12:01 AM
1/11/13 12:00 AM    1/11/13 12:02 AM
1/11/13 12:01 AM    1/11/13 12:01 AM
1/11/13 12:01 AM    1/11/13 12:01 AM
1/11/13 12:01 AM    1/11/13 12:02 AM

i used
awk '{$1=$2=strftime("%c",$1)} {print}' file

Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
Thu 01 Jan 1970 02:28:05 PM AST Thu 01 Jan 1970 02:28:05 PM AST
2

What does this number signify - 41285.000034722223 ?

3

hi,

you need to give awk the date you want to output

awk 'BEGIN{s=41285.001469907409; d=mktime("2013 11 1 0 0 0");print strftime("%F - %T",d+s)}'
2013-11-01 - 11:28:05
4

I guess that numbers are windows 1900 times? Not sure how to translate in unix unless you can give us 01/01/1970 in windows 1900 time.

5

Try this:

TZ=GMT awk '{
   print strftime("%m/%d/%y %I:%M %p", (($1 - 25569 ) * 3600 * 24)),
         strftime("%m/%d/%y %I:%M %p", (($2 - 25569 ) * 3600 * 24)) }' OFS='\t' infile
1 Like
6

many thanks to Chubler_XL
SOLVED