[Info-Ingres] Need Some Info

[Ball, David]

Puneet
 
With respect, how ingres stores dates is of little consequence here.
The important thing is how it represents them as character strings for
input & output, and here you're in luck because it can handle a large
number of different formats.
 
Check out the II_DATE_FORMAT environment variable/logical in the System
Administrator's Guide (Appendix A).
 
e.g. 
GERMAN > dd.mm.ccyy
MULTINATIONAL > dd/mm/yy
MULTINATIONAL4 > dd/mm/ccyy
FINLAND > ccyy-mm-dd
 
It is important to note that dates imported in one particular format can
then be displayed in any other format without changing the underlying
value.  That is, you may have a text file containing GERMAN dates, but
that doesn't mean that you're stuck with that format for everything else
you do in ingres.
 
HTH
Dave

________________________________

From: info-ingres-bounces at kettleriverconsulting.com
[mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of
Puneet Bagoria
Sent: 14 August 2007 16:15
To: Info-Ingres at kettleriverconsulting.com
Subject: [Info-Ingres] Need Some Info


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?
 
Regards,
Puneet
 
 

_______________________________________________________

Atos Origin and Atos Consulting are trading names used by the Atos Origin group.  The following trading entities are registered in England and Wales:  Atos Origin IT Services UK Limited (registered number 01245534) and Atos Consulting Limited (registered number 04312380).  The registered office for each is at 4 Triton Square, Regents Place, London, NW1 3HG.

This e-mail and the documents attached are confidential and intended solely for the addressee, and may contain confidential or privileged information.  If you receive this e-mail in error, you are not authorised to copy, disclose, use or retain it.  Please notify the sender immediately and delete this email from your systems.   As emails may be intercepted, amended or lost, they are not secure.  Atos Origin therefore can accept no liability for any errors or their content.  Although Atos Origin endeavours to maintain a virus-free network, we do not warrant that this transmission is virus-free and can accept no liability for any damages resulting from any virus transmitted.   The risks are deemed to be accepted by everyone who communicates with Atos Origin by email. 
_______________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070814/c11f29f2/attachment.html