Re: Time-Variable

Torsten = You can declare a column to be of type datetime hour to second to = accomodate the time-variable, like so: = create table ttime (ttime_col datetime hour to second); insert into ttime values(current); select * from ttime; = HTH = Sujit Pal ______________________________ Reply Separator __________________________= _______ Subject: Time-Variable Author: Torsten.Kleine.Buening@uni-muenster.de at internet Date: 6/18/98 4:37 PM Hello, = I am looking for the possibility to save a time, like '10:00:00', into = my db, the only variables, as I know, for those questions are DateTime or Date, isn't there a simple Time -Var ? = Or how do I get rid of these stupid date at the beginning of = the DateTime, I have to set, even if I tell the db DateTime Hour To Second. = We are using Online 7.22 (Aix). = MfG Torsten Kleine B=FCning =