Project 3 case study 2
I am currently working on case study 2 for project 3, which involves operational analytics and investigating metric spikes. During my work, I encountered an issue with importing a large database into MySQL. Despite ensuring the correctness of all my queries, I observed that the "createdat" column contains only null values in the result, contrary to what was demonstrated in the instructional video where there were no null values in the "createdat" column. I'm uncertain about how to proceed. Is it acceptable to have a null column, and can I move forward with my project? I would appreciate a prompt response. I would like to mention that I have already seen the video as well as used this string format. Still my columns are null . Used cast method also I have also attached the screenshot earlier Now I am sending it again. Please go through with it. PFA Importing Project 3 Dataset https://www.loom.com/share/fabb07d1168c47d0b27553b2e8aae1ea?sid=354ed789-0390-429f-a339-1bc5d9d7d197 You have to convert the string format into date time format. SELECT STRTODATE('20100212 103545', '%Y%m%d %h%i%s') As New_form;
