Mismatch in the date in DB and txt file
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,
Re: Mismatch in the date in DB and txt file
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 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.