Distinct value in the list box

[#1]

How to display distinct value in a list box?right now list box looks like

newtime
09.05
09.05
09.05
09.05
09.06

and in the script I am using below to populate the newtime field

time

(time#(log_time,'yyyyMMdd-hh:mm:ss'),'hh:mm') as newtime

log_time is a string field which looks like

20120927-09:05:01

20120927-09:05:02

20120927-09:05:03

is there a way list box can look like

newtime
09.05
09.06

[swuehl · Accepted solution]

Try

time#(time(time#(log_time,'yyyyMMdd-hh:mm:ss'),'hh:mm'),'hh:mm') as newtime

[erichshiino]

You can also try this:

maketime( hour ( time#(log_time,'yyyyMMdd-hh:mm:ss') ), minute( time#(log_time,'yyyyMMdd-hh:mm:ss') ) as newtime

Regards,

Erich

[#4]

thanks...