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 <Ken.Anderson@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.anderson@oasolutions.ca

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/