Convert data type into Date in Oracle

Options
Renga3037
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

Setup Info
    Tags
      Help me…