>1- How can I get the time from a datetime() field ?
>
>
>2- Which is the best way to deal with time in table fields, numeric or character ?
I am with Hugo.
DateTime fields are great just because you can make whatever calculations you want.
and TTOC(DTfield, 2)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.