Date and time conversion
Summaryissue by String to Date and Time
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