Tag: data-cleaning

I am unable to upload a .csv file in postgresql database because I don’t know how to put date structure in sql query

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 sa…

Omit certain characters from Rows in SQL

data-cleaning mysql rows 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 = 85…