all date columns in this db are defined as int and look weird. normally i would expect 8 digits (for YYYYMMDD) something like 20080131
but these have 10 digits and look weird. if i run
select top 10 myDateColumn from myTable order by myDateColumn desc
it returns like:
could you show me how to extract a proper datetime from this?