Convert data type into Date in Oracle

Renga3037
Level 1
Convert data type into Date in Oracle

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.

0 Kudos
2 Replies
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).

0 Kudos
Renga3037
Level 1
Author

Thank you so much for your response !!

0 Kudos