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.
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