Gabor Topor
Member
Hi, we tried to use getDate() in java client but it makes some time conversion. Let's see an example.
Our database holds a date field having value of 1st of January 2002 (01/01/2002). When we retreive it via SQL-92 interface with our java client getDate returns 31st of December 23:00.
So it seems, somehow it uses the op. system setting to convert the Progress date field to SqlDate type. We have tried to use Calendar and pass it to getDate function but it does not care about it.
My question is how can we use the same date value in our java application which is stored in the database.
I forget to mention the DB is running on AIX 4.3.3 and we use V9.1D SP3
Best regards,
Gabor
Our database holds a date field having value of 1st of January 2002 (01/01/2002). When we retreive it via SQL-92 interface with our java client getDate returns 31st of December 23:00.
So it seems, somehow it uses the op. system setting to convert the Progress date field to SqlDate type. We have tried to use Calendar and pass it to getDate function but it does not care about it.
My question is how can we use the same date value in our java application which is stored in the database.
I forget to mention the DB is running on AIX 4.3.3 and we use V9.1D SP3
Best regards,
Gabor