Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment