Skip navigation

    Log In

    Forgot your password?
    Want to become a partner? Sign Up
marketplace logo
5934 Views 1 Reply Latest reply: Jul 30, 2015 11:58 AM by Ravikumar Sanjeevi
Currently Being Moderated

Mar 16, 2017 12:03 AM

How to convert and load a string into the date/time field

Hi,

 

I'm facing an issue with the date field. I have to load the date column from file to table. I'm reading that filed as string and loading into the date/time filed.

My sample input data from flat file is '20150619 12:43 AM' i have to load this data into any of the date format. Here are the conditions that i have used to load the data:

 

> TO_CHAR(To_DATE(DATE))

> IIF(IS_DATE(DATE,'YYYYMMDD HH12:MMPM'),TO_DATE(DATE,'YYYYMMDD HH12:MM:SS'),null)

 

 

These conditions didnt workout and loading nulls into the target table. Please suggest me where im doing worng.

 

Thanks in advance.

More Like This

  • Retrieving data ...