Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Manchester, UK

    Unanswered: Date / Time types

    Hi, I'be just started to import data into sqlserver from ms access, and it automatically stores my dates as smallint length 4. Is this ok? For display purposes I want dd/mm/yyyy. Will 4 bytes store this?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I generally recommend DATETIME unless I know that the values can be stored properly in a SMALLDATETIME column. See the Using Date and Time data discussion in MSDN for more details.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts