> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Thursday, October 31, 2002 1:02 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Date Format in IB
>
> This is a Delphi problem, not an InterBase one. (This is a Firebird and
> InterBase support list.)

Sorry I did not know that it wasn't an IB problem.

> However, for a clue where to start looking for a solution...IB doesn't
> store dates in any format you would recognise as a date - it's a
> number.

Yes Alan and Pete mentioned this.

> Delphi knows it is a date field and by default displays it in
> controls as a string based on the Windows locale settings on the local
> machine. Depending on the components you are using for data
> access you can
> have more or less control over the output string displayed. Look at the
> DisplayText property of TField and the Format() function.
>
> What you see in controls doesn't have any effect on how IB stores
> the date.
>
> For more help on Delphi stuff, try one of the delphi forums on
> the Borland
> news server.

Thanks for the reply Helen and sorry to have been a nuisance

jackie