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 <[email protected] > 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* > > *[email protected]* <[email protected]> > > *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/
