Post reply

Changing smalldatetime field to datetime

  • July 11, 2012 at 3:39 am

    #277663

    Hi Guys,

    I want to change a field from smalldatetime to datetime because somedate have years like 1893 an so on....

    Should I expect any problems?

  • July 11, 2012 at 3:45 am

    #1511418

    Only if you have dates less than 1753.

    Also remember that datetime is 8 byte storage and smalldatetime is 4 byte storage, so keep an eye on page splits and fragmentation etc.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply