Hello
I need a function to convert unix ime into normal time for my brio report.
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