Shell Programming and Scripting

Hey guys.

1st problem:
I have to create a script for every hour run a script against a DB and then produce results to log file and eventually email.

I have to manipulate the date command from something like this

Code:

date '+%F %H:%M.%s'

which produces the below the below result

Code:

2014-08-01 15:20.1406920806

TO:
to be like this

Code:

>> 2014-08-01 15:20.140692

I need less digits to show of for %s command> I must maintain same format though for the script as it matches DB format.
Thanks!

Moderator's Comments:

Code tags for code, PLEASE!

You can get exactly what you asked for with

Code:

$ VAR=$(date +"%F %H:%M.%s")
$ echo ">> ${VAR:0:23}"
>> 2014-08-01 14:23.140692

...but I have my doubts that's what you actually want.

What, exactly, is your database's format? %s is not seconds, %s is epoch time -- the total number of seconds since Jan 1, 1970, the dawn of UNIX. Chopping 4 digits off that doesn't make sense, it wasn't always 10 digits long.

thanks for the heads up I though s% was a deatiled seconds but I was wrong... lol

Code:

date +"%F %H:%M.0000

it generates the right number of zeros for me to compare to system code epoch time ! `plus less work I dont need to round number the seconds column any more lol which was unnecessary

Thanks again Corona