[Info-Ingres] Need Some Info

[Mike Lay (News)]

Puneet Bagoria wrote:
> Hi ,
>  
> we are migrating data to an ingres database.
>  
> The data is in a flat file(text file, one record per line) with the vaues.
>  
> The text file is generated uing java program,  while creating the flat 
> file we need to change the data format as recognised by ingres.
>  
> we are facing problem to convert date format in java to the format 
> recognized by ingres.
>  
> Ingres stores date format like "3239.83".
>  
> Any suggestions?


abcde.fgh looks more like the sort of thing you get when you ask a 
TDateTime (Delphi/C++Builder) or a c time (or whatever the Java 
equivalent is) for a date. It supplies it as an offset from some 
previous point.

INGRES stores and reads dates as dates. Type

select date('now');\g

into the sql monitor and you'll get an example.

--
Mike Lay
email: newstrap @ Rees<secondpartname>.+.com (replace obvious symbols;-)