CONVERT(VARCHAR(10),
DATEADD(DAY, CAST(RIGHT(J_DATE, 3) AS INT) - 1,
DATEADD(YEAR, CAST(LEFT(J_DATE, 4) AS INT) - 1900, 0)), 23)
DB/MS SQL
CONVERT(VARCHAR(10),
DATEADD(DAY, CAST(RIGHT(J_DATE, 3) AS INT) - 1,
DATEADD(YEAR, CAST(LEFT(J_DATE, 4) AS INT) - 1900, 0)), 23)
댓글