| Author |
Message
|
| fagundes |
 Posted: Tue Mar 02, 2004 7:20 am Post subject: time data are wrong on the audit trail |
 |
|
Apprentice
Joined: 15 Aug 2003
Posts: 45
|
The time column of the audit trail table is with wrong informations. There is one difference about 3 hours from the machine clock. Please, how can I correct this ?
Thanks guys...
Fgaundes
_________________
Fagundes Pereira da Silva
M.Sc. Candidate / UFRJ Brazil
Interest Area: WfMS Performance Analysis |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Mar 02, 2004 8:45 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I think it might be GMT. Don't know what your timezone is but I bet its GMT+3
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Mar 03, 2004 8:04 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
MQ workflow uses universal cordinated time .
It's not only for audit trail but for processes/ workitems etc.
If you look at the client GUI (windows) the timings are correct with your machine clock.. But if you look at the data base it will be different (in UTC).
For audit trail you should incorporate the time zone factor in your queries.
regards
_________________
-manoj |
|
| Back to top |
|
|
| sanghaviamit |
| Posted: Thu Jul 27, 2006 3:01 am Post subject: GMT Timezone query |
|
|
Novice
Joined: 26 Jul 2006
Posts: 12
Location: India
|
| jmac wrote: |
| I think it might be GMT. Don't know what your timezone is but I bet its GMT+3 |
Hi John,
This is Amit Sanghavi here from AWPL. I want to know whether is there any way wherein we can change the GMT Time of the MQ Database to our local timezone. Pls advise.
Thanks,
Amit.
_________________
Regards & Thanks,
Amit Sanghavi. |
|
| Back to top |
|
|
| koko |
| Posted: Thu Jul 27, 2006 6:16 am Post subject: |
|
|
Master
Joined: 26 Sep 2003
Posts: 206
|
Jmac wrote
| Quote: |
I think it might be GMT. Don't know what your timezone is but I bet its GMT+3
|
I know that workflow uses in UTC for the audit trail. Is UTC not same as GMT for all practical purposes?
_________________
Thanks
Koko |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Jul 27, 2006 6:37 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| koko wrote: |
| Is UTC not same as GMT for all practical purposes? |
I believe that is the case.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| sanghaviamit |
| Posted: Thu Jul 27, 2006 9:01 pm Post subject: |
|
|
Novice
Joined: 26 Jul 2006
Posts: 12
Location: India
|
So there is no way to configure the timezone for database and we have to live with the GMT.
_________________
Regards & Thanks,
Amit Sanghavi. |
|
| Back to top |
|
|
| hos |
| Posted: Thu Jul 27, 2006 10:04 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
The API automatically calculates the local time according to your timezone.
So whatever client you are using, you have the local time.
I agree that there is no API for processing the audit trail records and so you see the UTC timestamps. This cannot be customized. |
|
| Back to top |
|
|
|
|
