Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Date and time conversion — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date and time conversion

Received Response
edited Dec 12, 2019 3:55PM in Integration 23 comments


issue 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




Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!