awk system date with -d option

arag0rn · #1 (**permalink**) 01-05-2008

Hi

I get problems when using the following command :

Code:

cat logs | awk -F";" '{ system("date -d "1970-01-01 UTC+0100 $1 seconds""); }'
date: date invalide `1968641199401200'
date: date invalide `1968641199381709'

this is what i have in my log file :

Code:

cat logs
1199401200;a
1199381709;b

I don't know where this 196864 comes form

Any idea ?

Thx

ghostdog74 · #2 (**permalink**) 01-05-2008

Code:

while IFS=";" read a b
do
    date -d "1970-01-01 UTC+0100 $a seconds"
done  < file

arag0rn · #3 (**permalink**) 01-05-2008

thx for this idea but it does not work for me

I made something that gives the same output your code should give but this is not what i am searching for :

Code:

for mytimestamp in $(cat logs| awk -F";" '{ print $1; }'); do echo $(date -d “1970-01-01 UTC+0100 $mytimestamp seconds”); done

What i want is to replace all the timestamps (first field) in a log file with the date in UTC+0100 format but i want to keep the other fields (file scheme)...

Franklin52 · #4 (**permalink**) 01-05-2008

If you have GAWK you can use the strftime function or you can fit the script of gostdog74 like:

Code:

while IFS=";" read a b
do
    echo $(date -d "1970-01-01 UTC+0100 $a seconds")";"$b
done  < file

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Compare date from db2 table to yesterday's Unix system date	sasaliasim	Shell Programming and Scripting	9	12-01-2008 11:37 PM
option followed by : taking next option if argument missing with getopts	gurukottur	Shell Programming and Scripting	2	03-17-2008 12:46 PM
I want to get day from the current system date	gopskrish	UNIX for Dummies Questions & Answers	2	06-24-2005 09:52 AM
system date	Prafulla	UNIX for Dummies Questions & Answers	1	02-01-2002 06:42 AM
file date vs. system date	ober5861	UNIX for Dummies Questions & Answers	8	09-11-2001 02:36 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by