Subject Re: IB_DateTimePicker for TIME field
Author gsbrown@GerBreOwn.com
--- In IBObjects@egroups.com, Helen Borrie <helebor@w...> wrote:
> At 04:17 PM 26-12-00 +0000, you wrote:
> >Helen,
> >
> >The DisplayFormat property is blank for this field. What should it
be
> >for a Time field?
>
> Try HH:MM:SS.
I used "99:99 AM" and this seems to work. I am just interested in
Hours and Minutes.
>
>
> >The error comes when it is picking up the value of the 'Date'
property
> >of the component.
>
> What datatype is it associated with? If an IB6/Dialect 3 DATE type
then
> there is no way you will get a valid time.
> You'd need a TIMESTAMP.

The datatype is defined as "TIME" in an IB6/Dialect 3 table.
>
> ib 4.x or 5.x DATE should be ok.
>
> Helen
>
>
>
> >Thanks,
> >
> >Gerald S. Brown
> >--- In IBObjects@egroups.com, Helen Borrie <helebor@w...> wrote:
> > > At 03:23 PM 26-12-00 +0000, you wrote:
> > > >In previous versions of IBO this component was working fine as
I
> >have
> > > >been using it for awhile. Now it says that 12/30/99 is not a
valid
> > > >time.
> > >
> > > That's true, it's not a valid time. '23:44:30' is a valid time.
> > >
> > > What do you have for the DisplayFormat property of the column?
> > >
> > > Helen
> > >
> > > All for Open and Open for All
> > > InterBase Developer Initiative · http://www.interbase2000.org
> > > _______________________________________________________
> >
> >
> >
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________