Date and time conversion

Summary

issue by String to Date and Time

Content

I have a scinario of getting String type Date and Time values from Source need to populate into DB as a timestamp fields.

I am facing issue for conversion of string to (datetime,date, time ) as DB timestamp format (YYYY-MM-DD HH-MM-SS) using ICS conversion functions which i tried date(),datetime() and time() are not working.

String input 2019-12-09 09:06:24 --Expected Output  as datetime type : 2019-12-09 09:06:24

String Input Date : 2019-12-09 ---Expected output as date type: 2019-12-09

String Input Time : 05:00 --Expected Output  as pure Time type: 05:00:00