Distinct hours:Mins

[jagannalla]

Hello,

i've date field like shown below:

DateColumn

2012-07-03 15:51:53.58

2012-07-03 15:52:21.74

2012-07-03 15:52:49.89

2012-07-03 15:53:18.54

2012-07-03 15:53:46.82

- I want to retrive the distinct dates and time. I can able to do for dates. But i can't do for time how can i achive this. For date i'm using

Date(Floor(DateColumn),'MM/DD/YYYY') as Date

I WANT DISTICNT TIMES

for example

15:51

15:52

15:53

[hic · Accepted solution]

Then you should truncate it to the nearest minute:

Time(Frac(Floor(Date,1/24/60)),'hh:mm')

HIC

[jagannalla]

His is correct.B'coz the timestamp values should align to right side of the column. Previous codes align to left side of the column.