BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

Convert date format(dd/mm/yyyy) into format (yyyy-mm-dd)


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
ursfriend77
Principal Member
Principal Member



Joined: 02 Mar 2011

Posts: 163



PostPosted: Sat Sep 21, 2019 4:10 am 
Post subject: Convert date format(dd/mm/yyyy) into format (yyyy-mm-dd)

How to convert date format(dd/mm/yyyy) into format (yyyy-mm-dd).

I have CSV file with date column having values like below

Date:
-----

3/5/2019 12:24:36 AM
12/6/2019 09:34:56 PM
9/12/2019 04:12:35 AM
1/10/2019 02:37:28 PM

I want to convert date values like below output

2019-05-03
2019-06-12
2019-12-09
2019-10-01

Please help me how to convert as my desired output.

Thanks
Venki
Back to top
BOBJFan
Principal Member
Principal Member



Joined: 24 Sep 2011

Posts: 138



PostPosted: Mon Sep 23, 2019 5:24 am 
Post subject: Re: Convert date format(dd/mm/yyyy) into format (yyyy-mm-dd)

Try to_date function
Back to top
jlynn73
Forum Associate
Forum Associate



Joined: 27 Oct 2009

Posts: 570
Location: DesMoines Iowa


flag
PostPosted: Mon Sep 23, 2019 9:18 am 
Post subject: Re: Convert date format(dd/mm/yyyy) into format (yyyy-mm-dd)

print(to_char( to_date( '9/12/2019 04:12:35 AM','MM/DD/YYYY HH:MI:SS'),'YYYY-MM-DD'));
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0233)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo