i am struggling to convert a date field which has the format in 19may2017:10:50:00 as date. The data is being loaded from SQL table and this how i am getting it. i am trying to make the change in the SQL load but not being successful
could you please assist?
may be Preceding LOAD like
LOAD Date(Floor(Timestamp#(Date,'DDMMMYYY:hh:mm:ss'))) as Date;
SQL Select Date
Retrieving data ...