If l understand correctly the issue is the returning a date/time instead of
the value that is held in the field in the tables in Remedy. The value for
date/time fields is Unix epoch time the number of seconds since 1st January
1900 00:00:00 ( http://en.wikipedia.org/wiki/Unix_time
http://en.wikipedia.org/wiki/Unix_time )
I use a TSQL function to convert it
FUNCTION [dbo].[fnConvertEpochDate]
(
-- Add the parameters for the function here
@pEpochDate int
)
RETURNS DateTime
AS
BEGIN
-- Declare the return variable here
DECLARE @Result DateTime
DECLARE @EpochDate as DateTime
SET @EpochDate = '1970-01-01 00:00:00'
-- Add the T-SQL statements to compute the return value here
SELECT @Result =DATEADD(second, @pEpochDate, CONVERT(DATETIME,
@EpochDate, 102))
-- Return the result of the function
RETURN @Result
END
This is used in SQL server 2005, and would need to change the format at the
end of the DATEADD function to return the date/time format you require.
If you are not using Sql server there are other examples for other DB's.
HTH's
--
View this message in context:
http://www.nabble.com/Very-Urgent%3A-Need-to-show-formatted-worklog-in-report-tp20656123p20682240.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
