TimeZone updates
Hi!
The problem with the update time. According to the update time in Russia.
Tried to do through the database:
- use servicedesk
- go
- update dbo.sduserprofile
- set TIMEZONEID = 400,
- DATE_FORMAT = 'dd.MM.yyyy',
- TIME_FORMAT = 'dd.MM.yyyy HH:mm'
- go
AND
- insert into dbo.sduserprofile
- (USERID,
- TIMEZONEID,
- DATE_FORMAT,
- TIME_FORMAT,
- SIGNATURE)
- select au.USER_ID,
- 400,
- 'dd.MM.yyyy',,
- 'dd.MM.yyyy HH:mm',
- NULL
- from dbo.aaauser au
- left join dbo.sduserprofile sd on au.USER_ID = sd.USERID
- inner join dbo.aaalogin lg on au.USER_ID = lg.USER_ID
- where sd.USERID is NULL;
Users now have a time zone that suits me. But when submitting the request, the time specified for an hour more. How to change time zone in servicedesk plus?