Need advise for register time values into table

[mierlp]

hi

 

Within my application a need several edit fields for register time (only HH:mm)

 

I use a mySQL database so i can use:

a. TIME field

b. DateTime field

c. Float

d. Var

 

I have to compare time (start/end times) and calculate times. When comparing time it's possible

a performance starts at 23:00 and ends at 00:30 hour. Do i need to use the date to correct

calculate the time?

 

Time fields have advantage and disadvantage and some people use float fields for time. I have used

a time field and when entering the time in a dbedit with the syntax HH:mm it's after save is show

always HH:mm:ss (because it's a time field). But after using a display field HH:mm it still show

the time like HH:mm:ss

 

So ...what's you opion for :

1. best field for time

2. when using a DBEdit for enter time i can use a mask like 99:99
3. tips ?

 

Regars Peter

[bugra]

Hi

 

You can use UniDBDateTimePicker and set TimeFormat HH:mm.