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
R&D
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 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.anderson@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/