Community Conundrum 28: News Engagement is live! Read More

Convert data type into Date in Oracle

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
Dataiker
Dataiker

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
Level 1
Author

Thank you so much for your response !!

0 Kudos
A banner prompting to get Dataiku DSS