Search code examples
sqldatetime2

Sql Server Datetime2: Eliminate the seconds part in datetime2

How can I eliminate the seconds part in my query. I have used DateADD to show the seconds part as 0 but I just want to ignore it. I only want to show the date hours: minutes I have used this query and it returns me something like this 

SELECT DATEADD(minute, DATEDIFF(minute,0,GETDATE()), 0)

2013-09-30 13:03:00.000

But I want only 2013-09-30 13:03 part.

Can anyone help me?

Solution

  • If you're dealing with a format, then what you have to end up with is a string, not a datetime value - datetimes (or datetime2s) don't have a format.

    So you need to convert to a string. There's no format that exactly matches what you're asking for, but if you do a conversion and don't give CONVERT enough space, it truncates the result:

    SELECT CONVERT(varchar(16),GETDATE(),120)