It looks abnoxious when as MS MVP I advocate MOF/MSF Database Designs for customers and USers but still one of our main System Databases named MSDB has columns which are related to Datetime have been kept as INT...
WHo Designed this Database and WHo pruned it... I wish to meet them .. God... It wasted my extra time and Extra resources to get them casted , So that my RDL can just publish the report on SYSJOB and SYSJOB HISTORY..
RUN_DATE and RUN_TIME why are they int type ?? By any standard both should have been Datetime Types.
It is not a BUG but a Flaw in Database Design Understanding???