Date Time conversion

[Avishek1]

Dear Expert,

I have a requirement to change the date time as described below can anyone help me on that.

Input : DD-MMM-YYYY HH:MM

output : YYYY-MM-DD HH:MM:SS

Also I have requirement to parse the value from a column link below

input: abc(xyz) 

output: xyz

only value within Parenthesis need to be in output.

[Qiu]

@Avishek1 

Hope this will work