I downloaded a csv file for practising where date format is of two types as shown in picture. the picture is here I tried to change the format to yyyy-mm-dd in excel but it is not happening. and also, I can’t upload the file in database in my postgresql. I used the data type “date” but it says I need
Tag: data-cleaning
Omit certain characters from Rows in SQL
I have a column that has Serial Numbers but some of them has unwanted characters attached with the Serial Number:- These are some of the entries from a Column in a SQL Table. I want to omit all the characters including and after the Underscore. For example, these values would become this:- 8558088363_AAC = 8558088363 7272505721_R2C = 7272505721 And keep