Date format problem

Designing Pipelines
#1

Hi,

I have a CSV file containing the dates like ‘16-DEC-2019’ and I am reading the CSV file and inserting it into an Oracle database table but it always errors out because the format desired is a date in format yyyy/mm/dd hh:mi:ss.

I have used the below expression but it returns NULL as well. Can you please help me how to get it corrected?

Date.parse($[‘Date From’]!= null ? $[‘Date From’].toString().substr(0,10) : $[‘Date From’]).toLocaleDateString({“format”:“yyyy/MM/dd HH:mm:ss”})

#2

@amit.saroha: Are you expecting the format yyyy/MM/dd HH:mm:ss for Null values?

#3

no, they can be null.

#4

There’s probably a number of ways to write this out, but try this expression:

$['Date From'] != "" ? Date.parse($['Date From'],'dd-MMM-yyyy').toLocaleDateString({"format":"yyyy/MM/dd HH:mm:ss"}) : null

It may still need to be tweaked for your use case.