convert date format to mysql date format in log file

Shell Programming and Scripting
1

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column.

I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this?

Sample input

02/27/09,23:52:31
02/27/09,23:52:52
02/27/09,23:54:53
02/27/09,23:57:46

Desired output

2009-02-27 23:52:31

thanks & regards

2

With GNU awk:

 gawk -F, '{split($1, a, "/"); print "20" a[3] "-" a[1] "-" a[2], $2}'
3

Another approach:

awk -F",|/" '{$0="20"$3"-"$1"-"$2" " $4}1'

Regards

4

Thank you guys. That worked perfectly. Appreciate it.

regards,