Skip navigation

    Log In

    Forgot your password?
    Want to become a partner? Sign Up
marketplace logo
6393 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



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:






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 ...