Re: Time-Variable
Posted in 1998
Martin Berns — — source: Informix-list mailing list archive (1991-1998)
Torsten Kleine Buening schrieb:
>
> 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 ?
The following works for me (Solaris 2.5.1. / IDS 7.30 and WGS 7.20):
create table t ( zeit datetime hour to second );
insert into table t values ('11:11:11');
>
> 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).
s.o.
>
> MfG Torsten Kleine B'ning
hth
martin