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/