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
45
Views
21
Comments
edited Dec 12, 2019 3:55PM in Integration 21 comments

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

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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