09-30-2010 12:41 PM
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?
10-01-2010 01:41 AM
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.