Thank you for your reply. As i looked at my data and what your SQL was doing, it doesn't appear that my numbers are stripped out time stamps. In one of the above posts a guy mentions that sometimes it's stored as the number of days since 1/1/1900. Do you know how to take a bigint like that and make it a normal date?

Here's some sample "dates" that i'm working with:

1196100822809

1196108435656

1196100810760

1196108412559

1196701846338

1196100817789

1196100854938

1196108456761

1196701886504