Considering supply chain attacks, a breech of a partner or supplier could have significant impact. The net effect is removing the time component. You then add that integer number of days to Jan 1, 1900. We are looking into sending a Vendor Security Assessment Questionnaire to all of our partners and providers, it's never been done by us previously. Select DateAdd (Day, DateDiff (Day, 0, GetDate ()), 0) DateDiff (Day, 0, GetDate ()) is the same as DateDiff (Day,, GetDate ()) Since DateDiff returns an integer, you will get the number of days that have elapsed since Jan 1, 1900.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |