How to Select only Date Hour and Minutes from 2017-09-27 15:39:36.000

Question

I have a column in my table (having value- 2017-09-27 15:39:36.000).

I want to select only Date, Hour, Minutes (i.e:- 2017-09-27 15:39) from column.

Can anyone please tell me how to select.?

What is the data-type of that column? datetime, datetime2 or something else. — Salman A, Sep 28 '18 at 05:58
Do you want to _display_ the output you showed us, or do you want to zero out the seconds component? These are not the same thing. — Tim Biegeleisen, Sep 28 '18 at 06:01
@TimBiegeleisen:- I want display as it is i shown i.e :- 2017-09-27 15:39 — Sanjiv, Sep 28 '18 at 06:02

Salman A · Accepted Answer · 2018-09-28T07:06:40.340

2

Use the FORMAT function to format the date:

SELECT FORMAT(CAST('2017-09-27 15:39:36.000' AS DATETIME), 'yyyy-MM-dd HH:mm')
-- 2017-09-27 15:39

edited Sep 28 '18 at 07:06

answered Sep 28 '18 at 05:59

Salman A

Only i need to select 2017-09-27 15:39 and :00.000 not to show – Sanjiv Sep 28 '18 at 06:01
1

@Sanjiv see revised answer. – Salman A Sep 28 '18 at 06:06

score 1 · Answer 2 · answered Sep 28 '18 at 05:58

1

One option would be to use CONVERT with a mask matching the format you want:

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

2018-09-28 07:58

Demo

We convert to varchar(16) explicitly so that only the hour and minute components are retained.

answered Sep 28 '18 at 05:58

Tim Biegeleisen

score 0 · Answer 3 · answered Sep 28 '18 at 05:54

0

Use the datepart function which can extract specific parts of the date value.

answered Sep 28 '18 at 05:54

Vlam