I need to fetch data from SQL DB to Outsystems using the Integration Studio.

One of the field in the table has "Timestamp" data type, converting it to text makes all the timestamp record become 'System.Byte[]' while the other 2 makes the aggregate can't display the data.

Any way i can get this Timestamp field to Outsystems?

Hi Kevin,

There are many Data conversion functions in OutSystems. You may checkout https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Data_Conversion

I believe DateTimeToText(DateTime) suits your problem statement.

Swatantra Kumar wrote:

Hi Kevin,

There are many Data conversion functions in OutSystems. You may checkout https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Data_Conversion

I believe DateTimeToText(DateTime) suits your problem statement.

Hi,

How to convert field data type inside Integration studio?