IDE field types vs. IB6 data type

Anton E

Delphi Developer

Sat, 29 Oct 2005 16:38:29 GMT

IDE field types vs. IB6 data type

Hi all,
I'm using D6/IB6
When I specify a new field (calculated) in CDS fields editor and select the type as 'DATE', which IB datatype does it resemble as
IB6's DATE field is similar to a DATETIME field created from IDE. Correct?

Thanks AntonE

Martijn Tonie

Delphi Developer

Sat, 29 Oct 2005 16:56:38 GMT

Re:IDE field types vs. IB6 data type

Hi,

Quote

> I'm using D6/IB6
> When I specify a new field (calculated) in CDS fields editor and select the

type as 'DATE', which IB datatype does it resemble as

Quote

> IB6's DATE field is similar to a DATETIME field created from IDE. Correct?

In dialect 1, a DATE holds both the date and the time.

In dialect 3, there's DATE to hold - a date!, TIME to hold time and TIMESTAMP to
hold both.

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com

Anton

Delphi Developer

Sat, 29 Oct 2005 18:32:48 GMT

Re:IDE field types vs. IB6 data type

Quote

> In dialect 1, a DATE holds both the date and the time.
> In dialect 3, there's DATE to hold - a date!, TIME to hold time and TIMESTAMP to
> hold both.

O.K.
Thank you
AntonE

Other Threads

1. Money field type same as Currency data type??

2. Invalid Field Type for nchar and nvarchar data types

3. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

4. datetime data type to smalldatetime data type conversion error

5. datetime data type to smalldatetime data type conversion error

6. ADO fields types and common field types?

7. Help - Invalid Field Type - New Field Types?

8. Indexing on string type vs. integer type

9. String field type data to time field

10. changing real type data to word type