Difference between revisions of "Understanding Service Desk Time"
m (→See Also) |
m |
||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
[[Category:Miscellaneous]] | [[Category:Miscellaneous]] | ||
| + | <div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br> | ||
| + | To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> | ||
| + | |||
| + | == Overview == | ||
This article shows how Service Desk maintains timestamps and how to convert it to real world time.<br> | This article shows how Service Desk maintains timestamps and how to convert it to real world time.<br> | ||
| + | |||
== Date/Time == | == Date/Time == | ||
| − | |||
| − | |||
The value in date field for USD are coming from a generation that predates Windows. USD was developed on and for UNIX systems. UNIX Time it is the number of seconds elapsed since midnight of January 1, 1970. | The value in date field for USD are coming from a generation that predates Windows. USD was developed on and for UNIX systems. UNIX Time it is the number of seconds elapsed since midnight of January 1, 1970. | ||
'''[USD time] 0 = [Real world] 1 January 1970 at 00h00:00''' | '''[USD time] 0 = [Real world] 1 January 1970 at 00h00:00''' | ||
| − | |||
The mathematic function for time is...<br> | The mathematic function for time is...<br> | ||
'''[Gregorian] dd/mm/yyyy h:m:s = [USD Time in second] value + 1/1/1970''' | '''[Gregorian] dd/mm/yyyy h:m:s = [USD Time in second] value + 1/1/1970''' | ||
| − | |||
For easy calculation...<br> | For easy calculation...<br> | ||
'''USD time / 86400 = number of days from 1970''' | '''USD time / 86400 = number of days from 1970''' | ||
| − | |||
| − | |||
The biggest problem with conversion is the non-linear scale of Gregorian date format (there are sometimes 28, 29, 30 or 31 days a month, 365 or 366 days a year). Conversion functions existing in your query or reporting tools are typically your best resource. | The biggest problem with conversion is the non-linear scale of Gregorian date format (there are sometimes 28, 29, 30 or 31 days a month, 365 or 366 days a year). Conversion functions existing in your query or reporting tools are typically your best resource. | ||
| Line 46: | Line 46: | ||
|- | |- | ||
|} | |} | ||
| − | |||
Note: Timestamps are always recorded in GMT +0 and the system times are displayed based on the timezone of the Primary Server. | Note: Timestamps are always recorded in GMT +0 and the system times are displayed based on the timezone of the Primary Server. | ||
| − | |||
== Duration == | == Duration == | ||
| − | |||
Duration is another type of time value used by Service Desk. While it is not a direct reference to time, it is the difference between two timestamps. | Duration is another type of time value used by Service Desk. While it is not a direct reference to time, it is the difference between two timestamps. | ||
| − | |||
'''duration = close_date - open_date''' | '''duration = close_date - open_date''' | ||
| − | |||
== External Links == | == External Links == | ||
| − | |||
[http://www.onlineconversion.com/unix_time.htm Unix Timestamp Converter] | [http://www.onlineconversion.com/unix_time.htm Unix Timestamp Converter] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 21:52, 25 July 2008
To discuss or ask questions about this article, select the discussion tab above.
Overview
This article shows how Service Desk maintains timestamps and how to convert it to real world time.
Date/Time
The value in date field for USD are coming from a generation that predates Windows. USD was developed on and for UNIX systems. UNIX Time it is the number of seconds elapsed since midnight of January 1, 1970.
[USD time] 0 = [Real world] 1 January 1970 at 00h00:00
The mathematic function for time is...
[Gregorian] dd/mm/yyyy h:m:s = [USD Time in second] value + 1/1/1970
For easy calculation...
USD time / 86400 = number of days from 1970
The biggest problem with conversion is the non-linear scale of Gregorian date format (there are sometimes 28, 29, 30 or 31 days a month, 365 or 366 days a year). Conversion functions existing in your query or reporting tools are typically your best resource.
| SQL | VB |
|---|---|
| DATE_ADD | DATEADD |
| DATE_PART | DATEDIFF |
| DATE_SUB | DATEPART |
| DATEADD | DATEVALUE |
| DATEDIFF | |
| SUBDATE |
Note: Timestamps are always recorded in GMT +0 and the system times are displayed based on the timezone of the Primary Server.
Duration
Duration is another type of time value used by Service Desk. While it is not a direct reference to time, it is the difference between two timestamps.
duration = close_date - open_date
