Convert data type into Date in Oracle

Renga3037

Hi All

I have generated system date through formula using now(), I want store in the oracle with 'Date' as data type format will be 'dd-MMM-YY' i.e 26-Aug-20.

I have tried many ways I couldnt achieve this. But I am getting data type as Timestamp or String(Nvarchar)

Any one give me a suggest or solution.

Thanks in advance.

Clément_Stenac

Hi,

Unfortunately, as you noted, DSS does not currently support writing DATE fields in SQL databases. It supports timestamp or string types.

Adding this capability is part of our backlog (although we do not currently have an ETA to announce for this).

Renga3037

Thank you so much for your response !!