Creating SQL reports from BEDB

[Dianne_Carbonne]

I'm trying to use a couple of the job history views to create a report.  It appears that the date fields (actualStartTime, etc) are stored in UTC format.  Has anyone found an easy way to convert that to local time?

[Colin_Weaver]

Not sure what table you are looking in - on my system when I run queries (in SQL Server Management Studio) against the JobHistorySummary and Job HistoryDetail tables - the ActualStartTime/StartTime fields are populated with the format YYYY-MM-DD HH.MM.SS.000

EDIT: An OSQL (Command Line) query into same table returns the same format.