Ken,
are you trying to create a database view?
There are fields stored as epoch in the database, that is the number of
seconds since 01-01-1970 UTC. This is the default date format on UNIXen. If
you have a MySQL database, you can convert it with the FROM_UNIXTIME()
command as follows:
SELECT FROM_UNIXTIME(escalation_response_time) FROM ticket
WHERE escalation_response_time 0
This will show the response time in 'human readable' DATETIME format.
--
Michiel Beijen
RD
OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Deutschland
T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I: http://www.otrs.com/
Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial
register: 10751, Tax ID: 003 240
97505 Chairman of the Board: Burchard Steinbild, Managing Board: André
Mindermann (CEO), Martin Edenhofer
CU@ IIR Service Desk Forum in Mainz (Germany) and get to know more about
OTRS at booth no. 12 from Nov 24-25, 2009!
On Sun, Oct 18, 2009 at 11:11 PM, Anderson, Ken ken.ander...@oasolutions.ca
wrote:
I’m trying to create a view that displays the integer values of the
“time” columns in TICKET recognizable dates and times.
How should I do this?
Thanks,
-Ken
*Ken Anderson*
*Manager, Managed Services*
*OA Solutions*
*Victoria*Vancouver*Edmonton*
*tel. (250) 385-4333 x219*
*fax. (250) 483-3380*
*ken.ander...@oasolutions.ca* ken.ander...@oasolutions.ca
*www.oasolutions.ca* http://www.oasolutions.ca/
*Please note that effective October 1, 2009 OA Solutions' Victoria Office
has moved. Our new address is:*
*200 - 702 Fort Street*
*Victoria, BC V8W 1H2*
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/