Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to convert date into YYYY-MM-DD — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to convert date into YYYY-MM-DD

Received Response
1
Views
4
Comments

Summary:

How to convert date 28-FEB-23(DD-MM-YY) into YYYY-MM-DD


Content (required):

Hi Expert,

We are receiving the date like 28-FEB-23 from client ,Now we want to store into the Database but DB accepts only YYYY-MM-DD format.

I have tried with xp20:format-dateTime (ns21:Transaction_date, "YYYY-MM-DD" ) but it didn't work,it is sending empty field to DB.

I have tried with concat (substring-after(substring-after(ns21:Transaction_date,'-'),'-'),'-',substring-before (substring-after (ns21:Transaction_date,'-'),'-'),'-',substring-before(ns21:Transaction_date,'-'))

But in this case the date 28-FEB-23 is getting converted to 23-FEB-28 But still i am not able to insert as it is in YY-MM-DD format.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!