Forum Discussion
Solved
split or extract?
Hi, I have a column including datetime that the format is 2025-07-07 at 12:40. Which one solution is better? "split by using delimiter at" or "apply a tramsform to extract the column first 11 cha...
mamatea1218 If format is constant then extracting first 11 characters is good because Extracting a fixed number of characters is generally faster and less error-prone and It is straightforward if the date part is always exactly 11 characters long.
If there is any possibility of variation in the format, splitting by delimiter might be a safer choice.
The format is constant. I think that the answer should be "extract......".
Practice question:"....You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy...."
"Split" will create one more column "Time" ,and it mentions "use a built-in date hierarchy". To minimize data model, "extract" is better than "split".