Support Questions
Find answers, ask questions, and share your expertise

How do we convert Execute Sql record unixtimestamp format result into normal datetime format ?

Explorer

I am using ExecuteSqlRecord and whatever result is coming for datetime related column, coming as unixtimestamp format, for this I tried to configure JsonRecordSetWriter service Timestamp format as "MM/dd/yyyy HH:mm:ss", eventhough I am getting unixtimestamp format. As such I have selected Schemat Strategy as "Do not write schema". 

0 REPLIES 0