formats
-
MSSQL Datetime formatsDatabase/MSSQL 2018. 10. 15. 09:17
출처: https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/ Date and Time Conversions Using SQL Serverwww.mssqltips.com 아래 표에는 없는 형식 변환법 (한국식 날짜 변환)Select Convert(varchar, getdate(),121) => 2016-04-05 09:28:25.003Select Convert(varchar(10), getdate(),121) => 2016-04-05Select Convert(varchar, getdate(), 120) => 2016-04-05 09:28:25 DATE FORMATSFormat #Query (current..