How do i set the data to run by unique dates and time only

Databases
1

This is what i have
select * from blackcar.dbo.viewlog_archive where viewlog_date_time > ‘2014-12-01 00:00:00.000’ and text_message like ‘BAIL%’ and car_no like ‘%’
this is what i get
Ex:
12/1/14 11:25 331 BAIL OUT GRANTED!
12/1/14 11:25 331 BAILOUT OFF AIR FOR 120 MINUTES
im looking to have it by only unique dates and time only
Ex:
12/1/14 11:25 331 BAIL OUT GRANTED!

2

So how would you choose between the two statuses?

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.