How to merge two rows in SQL Server

Question

I have a table similar to this one:

Date     | Cond   | Time
---------+--------+------
18/03/19 |   1    | 13:07
18/03/19 |   0    | 16:07

I want to have a selection that would produce thing similar to that using join or union or any sort of condition

 Date     | Time1 | Time2
----------+-------+------
 18/03/19 | 13:07 | 16:07

Best regards

Answer 1

You can use conditional aggregation:

select date, max(case when cond = 1 then time end) as time_1,
       max(case when cond = 0 then time end) as time_0
from t
group by date
order by date;

Answer 2

use aggregate function

select date,min(time),max(time)
from table group by date