Transact-SQL: How to get only date (yyyy-mm-dd) from datetime
(132)
-- How to get shordate from full date format
-- Input: date (datetime) Output: yyyy-mm-dd (varchar)
SELECT
CONVERT(VARCHAR(10),GETDATE(),120) as Date
Home
> Transact-SQL > Transact-SQL: How to get only date (yyyy-mm-dd) from datetime
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
