[SQL] MySQL & SQL SERVER 日期轉換

Una
1 min readMar 21, 2019

--

將日期格式轉為2019–11–29

MySQL

date_format( DATE, ‘%Y-%m-%d’)

SQL Server

CONVERT(VARCHAR(100), DATE, 23)

--

--

Una
Una

Written by Una

Hello. This is my code note.

No responses yet