Convert data type into Date in Oracle
Renga3037
Registered Posts: 9 ✭✭✭✭
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.
Answers
-
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).
-
Thank you so much for your response !!