I have a datetime field as "2018-11-08T11:23:34+0000". I want to add this to database in a datetime type column. I'm using totime("11:23:34") but the 'seconds' field always showing '00'. How do I update 'seconds' field in database?
Discussion posts and replies are publicly visible
Hi if you just try to write the datetime string to a datetime column in DB, you can do something like separate the date and the time from the input string, then do todate([date])+totime([time]). Now it becomes a datetime in Appian and you can assign it to a CDT field and write to DB like normal (if you just use todatetime([entire string]) Appian will set "seconds" value to 0)
Hope this help