'Dbeaver SQL Cast Convert

I am a beginner of SQL and I am using Dbeaver.

I connected Excel csv data to my Dbeaver working space and all the date format is string

So to do some work, I want some columns to be integer but cast and convert function doesn't work

Select Cast(total_cases AS int)

Select convert(int, total_cases)

These codes do not work at all..

Could anyone help me?

sql casting dbeaver

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source