Skip to content

Instantly share code, notes, and snippets.

@imrexhuang

imrexhuang/SQL Server的datetime格式取出日期和月份

Created April 9, 2016 15:15
Show Gist options
  • Save imrexhuang/fb35e94c2e2b25a99cdee6a10b69cd79 to your computer and use it in GitHub Desktop.
Save imrexhuang/fb35e94c2e2b25a99cdee6a10b69cd79 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL Server的datetime格式取出日期和月份
USE AdventureWorks2014
SELECT CONVERT(char(7), OrderDate,21) AS 訂單月份,
CONVERT(char(10), OrderDate, 21) AS 訂單日期,*
FROM Sales.SalesOrderHeader
ORDER BY OrderDate DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment