Please help, does anyone know how to return only the date part of the sql datetime field. Or how to convert an integer field to a date field, for example I need to convert this integer 20060223 to a date field. The sysjobhistory table stores the run_date as an integer and I need to query sysjobhistory for run_date = getdate() but because the type is different, they cannot be compared. I'd really appreciate any feedback you may have. Ciao
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!