Convert a five digit date to MM/DD/YYYY in the data load

[jerryr125]

Hi - My data contains a five digit date (example : 44340) should be 05/24/2021.

How do I convert the date in the data load ?

Thanks - Jerry

[Nicole-Smith · Accepted solution]

It should be as simple as wrapping your field in the date() function with the format that you want to see it in:

SELECT date(FieldName, 'MM/DD/YYYY') AS FieldName
FROM YourSource;

[jerryr125]

Thanks - I got it work - dates can be tricky at times - trial and error - jerry

[Nicole-Smith · Accepted solution]

Great!  I'm glad to hear the simple solution worked otherwise it would have taken much more digging.