[Info-Ingres] Is there a long data type in Ingres ?

[David Greenberg]

Thanks for your answer, but I forgot to mention that we are on
Ingres II 2.0/0011.

Grant Croker wrote:
> On 14/08/07 11:29, David Greenberg scribbled:
> 
>>Hi
>>The date data type in Ingres contains the date and time in the format of 
>>hh:mm:ss.
>>Is there a longer data type that would contain also tenths of seconds , 
>>hh:mm:ss.aaa  ?  (similar tot datetime data type of SqlServer)
>>  
> 
> Hi David,
> 
> Ingres 2006 r2 and later have support for timestamps with a second
> precision up to 9 decimal places, i.e. hh:mm:ss.aaaaaaaaa, as
> demonstrated by the following SQL:
> 
> /* timestamp(n) where  n is value from 0 to 9 */
> create table timestamps ( index integer not null, timestamp timestamp(3)
> not null)\p\g
> insert into timestamps values (1, '2007-02-08 16:41:00.12345')\p\g
> insert into timestamps values (2, '2007-02-08 16:41:00.54321')\p\g
> select * from timestamps\p\g
> Executing . . .
> 
> 
> ┌─────────────┬───────────────────────────────────────┐
> │index        │timestamp                              │
> ├─────────────┼───────────────────────────────────────┤
> │            1│2007-02-08 16:41:00.123                │
> │            2│2007-02-08 16:41:00.543                │
> └─────────────┴───────────────────────────────────────┘
> (2 rows)
> continue
> *
> 
> See http://docs.ingres.com/sqlref/UnderstandingSQLDataTypes for more info.
> 
> regards
> 
> grant
> 
>