Professional Web Applications Themes

What data type to use? - Microsoft SQL / MS SQL Server

DateTime data type according to SQL Server Books on line can store dates between 1753 and 9999 years. SmallDateTime even narrower. What Data Type should I use If I need to store dates before January 1st of 1753? Thank you Vlad...

  1. #1

    Default What data type to use?

    DateTime data type according to SQL Server Books on line can store dates
    between 1753 and 9999 years. SmallDateTime even narrower.
    What Data Type should I use If I need to store dates before January 1st of
    1753?
    Thank you
    Vlad


    Vlad Guest

  2. #2

    Default Re: What data type to use?

    varchar

    There is no native datatype that can handle dates that old, so just store
    them as strings. I would use ISO format when storing them: yyyymmdd, so
    sorting will work correctly.

    Bob Barrows

    Vlad wrote:
    > DateTime data type according to SQL Server Books on line can store
    > dates between 1753 and 9999 years. SmallDateTime even narrower.
    > What Data Type should I use If I need to store dates before January
    > 1st of 1753?
    > Thank you
    > Vlad

    Bob Barrows Guest

  3. #3

    Default Re: What data type to use?

    Thank you, Bob
    I had a problem with an attempt to set Date of Birth (if it's not available
    for some people and not required) in VB.NET class module to NULL. I found a
    work around by replacing Date type with String. Then I asked on VB.NET forum
    if I will have any problem in future with that replacement. I was told that
    it's very bad idea and bla-bla without any explanation.
    As you say in SQL Server it's normal
    Thank you again
    Vlad

    "Bob Barrows" <reb_01501> wrote in message
    news:uR$2uLBQDHA.2852tk2msftngp13.phx.gbl...
    > varchar
    >
    > There is no native datatype that can handle dates that old, so just store
    > them as strings. I would use ISO format when storing them: yyyymmdd, so
    > sorting will work correctly.
    >
    > Bob Barrows
    >
    > Vlad wrote:
    > > DateTime data type according to SQL Server Books on line can store
    > > dates between 1753 and 9999 years. SmallDateTime even narrower.
    > > What Data Type should I use If I need to store dates before January
    > > 1st of 1753?
    > > Thank you
    > > Vlad
    >
    >

    Vlad Guest

Similar Threads

  1. Converting from data type varchar to data type money
    By schaudry in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: June 10th, 11:01 PM
  2. Converting data type varchar to data type money
    By schaudry in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 10th, 07:22 PM
  3. retriving data from memo data type of msaccess to asp.net
    By Aneesh a in forum ASP.NET Web Services
    Replies: 0
    Last Post: May 7th, 01:11 AM
  4. Replies: 3
    Last Post: October 18th, 06:56 AM
  5. Replies: 2
    Last Post: October 16th, 08:29 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139