I have a SQL Table with X being a date column and varchar as Datatype. I need to retrieve non-monday days from the column. Can someone help here to retrieve the information.
Table – Time
Column – X
Data Type – Varchar
example table
X
2024-07-05
2024-07-08
2024-06-26
2024-06-24
2024-05-27
2024-05-20
2024-05-15
2024-05-16
Looking for the result in the same format as mentioned in the example table
Expected result-
X
2024-07-05
2024-06-26
2024-05-15
2024-05-16
Can someone help me how to tackle this?
Any help is appreciated!Thanks
New contributor
teju rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.