Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Great! I'm glad to hear the simple solution worked otherwise it would have taken much more digging.
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;
Thanks - I got it work - dates can be tricky at times - trial and error - jerry
Great! I'm glad to hear the simple solution worked otherwise it would have taken much more digging.