Shell Programming and Scripting

There are two columns on the data base table, create and update timestamps of datatype timestamp.

I dont have these fields on the csv file. So I am doing the below.

awk -F , -v d="$(date "+ %Y-%m-%d-%H.%M.%S")" '{ OFS=FS; print $1, $2, $3, $4, d, $5, $6, d }' temp.csv > temp1.csv

and then I insert the data to the table. Its inserting the data fine to the table.

But it throws the below warning for each row its inserting when I run the script.

How do I get rid of this warning ?

SQL3129W The date, time, or timestamp field containing "2011-04-14-16.22.39"
in row "1" and column "8" was padded with blanks.

Thank you in advance.

which database are u using? sql can be various depends on different database.

and have you tried this format?

'2011-04-14 22:22:22.2'

This is a database issue, not a shell script one.

In any event, my suggestion is to replace the '-' with space between the date and the time:

Code:

"2011-04-14 16.22.39"

actually I initially tried with space ..but then it would throw this message
and also it would not insert the row to the table..

SQL3148W A row from the input file was not inserted into the table. SQLCODE
"-180" was returned.

SQL0180N The syntax of the string representation of a datetime value is
incorrect. SQLSTATE=22007