Respected Contributor.
Respected Contributor.

Mismatch in the date in DB and txt file

Hi Experts,

While importing data via import descriptor, open time of IM is showing different.

Eg : In txt file open time is 1/31/2019  1:26:11 PM  and in db it is getting updated as

1/31/2019  1:26:11  and the expected value in db is

1/31/2019  13:26:11 .

Could you please help me to achieve this.

Thanks & Regards,

Sandhu Mol

1 Reply
Honored Contributor.
Honored Contributor.

Re: Mismatch in the date in DB and txt file

Hello Sandhu

do you have the proper time zone set up in the server, this could affect the time displayed on the records.

there are various ways to set this up, there is the parameter that you can put in the sm.ini https://docs.microfocus.com/SM/9.60/Codeless/Content/parameters/reference/startup_parameter_servertz.htm

you can change it in the system information record as well as the operator record.

hope this helps.


If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.