DB/MS SQL
[MS SQL]줄리안 데이트 -> YYYY-MM-DD 로 바꾸기
DeveloperJW
2023. 8. 30. 16:04
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)