Hi all,
When I create the sequential dump for a table which has date field in it the value for that date field in the file is 15000031121999.

The actual date is 01/01/2000 00:00:00

When I write a query on that table & I check the value for it show me 946652400, which I think is the date and time in UTC long format.

Can any one please help me how the number 15000031121999 in generated in the dump file? What is the date formate used while writing the sequential dump file in Baan LN?

When I create the sequential dump for a table which has date field in it the value for that date field in the file is 15000031121999.

The actual date is 01/01/2000 00:00:00

When I write a query on that table & I check the value for it show me 946652400, which I think is the date and time in UTC long format.

Can any one please help me how the number 15000031121999 in generated in the dump file? What is the date formate used while writing the sequential dump file in Baan LN?
Reply With Quote

Hi Rahul ,

The date in the sequential dump file is actually in the form

15(seconds)-00(minutes)-00(hours)-31(date)-12(month)-1999(year)

It is not in UTC long format .

The actual date you get after import is 01/01/2000 00:00:00 which is slightly different from the date in the flat file ..

This is because the dump of the table is from some different timezone and you are importing the table in different timezone .

Try using
date.with.timezone.info.to.utc()
local.with.timezone.info.to.utc()

Regards,
Niraj

Hi all,

Thanks a lot Niraj for your immediate reply.

15(seconds)-00(minutes)-00(hours)-31(date)-12(month)-1999(year)

Above quoted text is the format for the UTC date in the sequential dump file. Is there any way to know the date format, because I have one sequential dump file of BaanIVc4 table where I think the date is in format MMDDYYYY.

Thanks in advance.
-Rahul