Hi, I’m trying to extract the prompts used in our reports for an audit report. The Audit DB, the CMS and the reporting DB are all on SQL Server and the date value stored for the prompt has numerical values - e.g.
1362873600000
Does anyone know how to convert this to a datetime field?
I’m on BO4 SP4.
Thanks,
jo_68 (BOB member since 2011-06-02)
I think I’ve got it. It looks like the number is the number of milliseconds since January 1s 1970 - I tested a few of the figures in the column against this website:
and they came out ok. I’m going to use:
DATEADD (s, ((Event_Detail_Value /1000)), ‘1/1/1970’) to convert the field for my report.
jo_68 (BOB member since 2011-06-02)
This was EXACTLY what I was looking for and gave me what I needed. Thanks.
swnewlove (BOB member since 2010-07-01)