Changing String in SQL Table Columns

Question

I have a SQL Table with the column date, with each entry being a string in the format YYYY-DD-MM (I know it should be a Date data type, but I'm just accessing the data). I would like each entry in the column to be a string in the format YYYYDDMM (without the dashes). Basically stripping the dashes from the string.

Sean Lange · Accepted Answer · 2018-08-01 20:23:00Z

3

The absolute best thing would be to fix the tables and change the datatype to the proper one.

But to answer your question is really just a basic replace.

update YourTable
Set YourFauxDateColumn = replace(YourFauxDateColumn, '-', '')

answered Aug 1, 2018 at 20:23

Sean Lange

33.7k3 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sean Lange Over a year ago

Can you explain "didn't work"? The code posted would remove all occurrences of a hyphen (dashes) in the column.

Collectives™ on Stack Overflow

Changing String in SQL Table Columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related