We’re using Fastpath and I’ve been requested to write an sql query displaying the number of chats an operator received on a given date. I can’t for the life of me figure out how to convert the MSSQL date to something intuitive (for example 2009-01-01). Any help anyone could give me would be greatly appreciated.
Anyone?
Sorry this is a bit over a year for an answer. But I just got started with fastpath last month.
Here is the SQL you need to convert the java long to a SQL DateTime
SELECT [sessionID]
,[agentJID]
,dateadd(ss, cast([jointime] as bigint)/1000,'19700101') AS joinTime
,dateadd(ss, cast([leftTime] as bigint)/1000,'19700101') AS leftTime
FROM [openfire].[dbo].[fpAgentSession]
order by joinTime asc