Subject Re: Time format
Author Svein Erling Tysvær
> Hi!

Hi Primoz!

> I have a field type Time. Time is stored in format hh:mm:ss.

No, it isn't, it is stored as hh:mm:ss.nnnn.

> How can I define format to hh:mm ?

I don't think you can, but you could try to

EXTRACT(HOUR FROM <TimeVariable>) and

and combine them in a before insert trigger, hopefully making the
seconds always end up as 00.

By the way, never hijack a thread in this list like you did (you chose
reply to Lee's post and simply changed the subject). This means that
some people will never actually read your mail, whereas others who
view the mail threaded will see your mail intertwined with the SQL
Help thread (hence, I chose to start a new thread for this reply).