EXEC sp_who2 LastBatch showing future date

Question

I am receiving future dates in LastBatch column when i run EXEC sp_who2 on SQL Server.

for example most of the SPIDs have 5/14 as LastBatch date. (which means 2014)

And my first 20 row has 04/28 as LastBatch date. (which means 2028)

Any idea why i am seeing future dates in this column?

Is it normal?

Darren · Accepted Answer · 2013-05-14T10:11:32.347

1

I think you're misinterpreting whats going on.

04/28 indicates 28/04 (28th of April) - not 2028.

5/14 indicates 14th May - Todays date.

edited May 14 '13 at 10:11

answered May 14 '13 at 10:01

Darren

You are right. I was exporting this data into excel and excel converts it as 2028! I just figured it out. Thanks. – thatthing May 14 '13 at 10:09

1 Answers1