Search
Submit a request
Sign in
How can we help you today?
Categories
Submit a request
Submit a request
Sign in
Support
Community
SQL Prompt code snippets
FormatDate
New post
Snippet name: fd
Description: Format a date as YYYY-MM-DD
Code:
CONVERT(CHAR(10), <inDate, DateTime, GETDATE()>, 23) AS [Date]
Use Ctrl-Shift-M to populate the parameter.
Defaults to GetDate()
Bill_Ross
May 24, 2010 10:39
-
0
+
Add comment
Please
sign in
to leave a comment.
Description: Format a date as YYYY-MM-DD
Code:
CONVERT(CHAR(10), <inDate, DateTime, GETDATE()>, 23) AS [Date]
Use Ctrl-Shift-M to populate the parameter.
Defaults to GetDate()