Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Ben on January 01, 1970, 12:00:00 AM

Title: Brio Report Time change
Post by: Ben on January 01, 1970, 12:00:00 AM

Hello
I need a function to convert unix ime into normal time for my brio report.

Title: Brio Report Time change
Post by: Tony Tillyer on January 01, 1970, 12:00:00 AM

Hi Ben,

What is the time format you are using, when you refer to it as "UNIX" time? Is is x seconds past 01/01/1970 (UTC) or something similar?

There is a case convert available in Brio for most time formats:

Convert(varchar,getdate(),xx)

The "xx" refers to a date/time format for output. Available date/time formats for output are:

Convert(varchar,getdate(), 1) - Output in mm/dd/yy
Convert(varchar,getdate(), 2) - Output in yy.mm.dd
Convert(varchar,getdate(), 3) - Output in dd/mm/yy
Convert(varchar,getdate(), 4) - Output in dd.mm.yy
Convert(varchar,getdate(), 5) - Output in ddmmyy
Convert(varchar,getdate(), 6) - Output in dd Mon yy
Convert(varchar,getdate(), 7) - Output in Mon dd, yy
Convert(varchar,getdate(), 8) - Output in hh+:mi:ss
Convert(varchar,getdate(), 9) - Output in Mon dd yyyy hh:mi:ss:mmmXM
Convert(varchar,getdate(), 10)- Output in mmddyy
Convert(varchar,getdate(), 11)- Output in yy/mm/dd
Convert(varchar,getdate(), 12)- Output in yymmdd
Convert(varchar,getdate(), 13)- Output in Mon dd yyyy hh+:mi:ss:mmm
Convert(varchar,getdate(), 14)- Output in hh+:mi:ss:mmm

I hope this helps?

Tony