File:
a smallint
b timestamp
c date
d varchar

O/P:
a smallint
dateformat(b,'YYYY-MM-DD HH:NN:SS.sss')
dateformat(c.'YYYY-MM-DD')
d varchar

awk '{if ($2=="timestamp") {$3="dataformat("; }; print $3 $1 ",'''YYYY-MM-DD HH':'NN':'SS'.'sss)" else ($2=="date") {$3="dataformat("; }; print $3 $1 ",'''YYYY-MM-DD)" }' test.out