Skip to content

Instantly share code, notes, and snippets.

@devlights

devlights/sqlserver-date-convert.sql

Created March 9, 2015 05:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save devlights/993f484c705c6897d8c2 to your computer and use it in GitHub Desktop.
Save devlights/993f484c705c6897d8c2 to your computer and use it in GitHub Desktop.
Download ZIP
[SQLServer] 日付の文字列変換 (CONVERT, 111, 108, 120)
Raw
sqlserver-date-convert.sql
DECLARE @d DATETIME = GETDATE();
-- yyyy/MM/dd HH:mm:ss
SELECT CONVERT(NVARCHAR, @d, 111) + ' ' + CONVERT(NVARCHAR, @d, 108)
-- yyyy-MM-dd HH:mm:ss
SELECT CONVERT(NVARCHAR, @d, 120)
@devlights
Copy link
Author

参考リソース

http://teabreak.info/%E3%83%A1%E3%83%A2/sql-server-%E6%96%87%E5%AD%97%E5%88%97%E3%81%8B%E3%82%89%E6%97%A5%E4%BB%98%E5%9E%8B%E3%81%B8%E5%A4%89%E6%8F%9B/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment