Convert date to MM//DD HH/MM

Question

How do you convert date to MM/DD HH/MM

example: 04-05 12:42

Looks like that question is about converting a string to a date, so not really a duplicate. — Jacob, Apr 06 '17 at 01:00

score 2 · Accepted Answer · answered Apr 05 '17 at 18:47

2

Since you are on SQL Server 2012, use FORMAT:

SELECT FORMAT(GETDATE(), 'MM-dd HH:mm')

answered Apr 05 '17 at 18:47

Code Different

score 0 · Answer 2 · edited Apr 05 '17 at 19:33

0

Try using the MONTH, DAY, HOUR, MINUTE functions in T-SQL and concatenate your results into a string form like:

CONCAT(STRING(HOUR(created_at)), ':', RIGHT(STRING(MINUTE(created_at)), 3)) AS hour_min

Where the created_at is your timestamp column. Hope this helps!

edited Apr 05 '17 at 19:33

marc_s

answered Apr 05 '17 at 18:46

William Knighting

2 Answers2