updare dateid in table

Question

HI,

Hw to update date datatype into integer column to varchar column

create table table1(dateid date,dateid1 int,dateid2 varchar(23) )

dateid --------------------- dateid1 -------------dateid2

2024-01-01 ------------------20240101---------------- 2024 Jan 01

Answer 1

Hi @RUPESH SHELAR

Try this:

UPDATE table1
SET dateid1 = CAST(CONVERT(varchar(8),dateid,112) as int),
    dateid2 = CONCAT_WS(' ',YEAR(dateid),convert(varchar(6),dateid,107))

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Two ways, one working on the date column and one on the id column.

SELECT concat_ws(' ', date1%10000, left(datename(month, convert(date, convert(char(8), dateid1))), 3), right(convert(char(8), dateid1), 2))