Tech Off Post

Single Post Permalink

View Thread: Question - What would you do?
  • User profile image

    Maddus Mattus said:

    Store year as an int if you dont need a datetime,..


    Storing DateTime if you only need year is overhead.

    The effect is negligible. an int is 32 bits, a datetime is 64 bits. On an x64 DBMS the int would be padded out to 64-bits to fit into a word size, so it's possible that the overhead is with using an int rather than a 64-bit type Wink