Professional Web Applications Themes

Data type query - Microsoft SQL / MS SQL Server

Hi I have to specify in a table certain values for: Minutes duration spent on phone-eventduration, the eventdate-which date, and event time- exact time I was wondering in your opinon which are the best data types to use for these values...

  1. #1

    Default Data type query

    Hi I have to specify in a table certain values for:
    Minutes duration spent on phone-eventduration, the
    eventdate-which date, and event time- exact time
    I was wondering in your opinon which are the best data
    types to use for these values
    shau Guest

  2. #2

    Default Re: Data type query

    Hello, shau!

    To store the amount of Minutes you can use a variation of integer (integer,
    smallint, tinyint) depending opn how long you expect the conversation to be.

    If you need the Event Start date to the millisecond then DateTime will do
    it.

    SQL Server does not split DATE and TIME hence the name DATETIME

    BOL has a good section on datatypes


    --

    Allan Mitchell (Microsoft SQL Server MVP)
    MCSE,MCDBA
    [url]www.SQLDTS.com[/url]
    I support PASS - the definitive, global community
    for SQL Server professionals - [url]http://www.sqlpass.org[/url]

    : Hi I have to specify in a table certain values for:
    : Minutes duration spent on phone-eventduration, the
    : eventdate-which date, and event time- exact time
    : I was wondering in your opinon which are the best data
    : types to use for these values
    --- Microsoft CDO for Windows 2000


    Allan Mitchell Guest

  3. #3

    Default Re: Data type query

    Thanks Alan I needed that direction
    cheers

    >-----Original Message-----
    >Hello, shau!
    >
    >To store the amount of Minutes you can use a variation of
    integer (integer,
    >smallint, tinyint) depending opn how long you expect the
    conversation to be.
    >
    >If you need the Event Start date to the millisecond then
    DateTime will do
    >it.
    >
    >SQL Server does not split DATE and TIME hence the name
    DATETIME
    >
    >BOL has a good section on datatypes
    >
    >
    >--
    >
    >Allan Mitchell (Microsoft SQL Server MVP)
    >MCSE,MCDBA
    >[url]www.SQLDTS.com[/url]
    >I support PASS - the definitive, global community
    >for SQL Server professionals - [url]http://www.sqlpass.org[/url]
    >
    >: Hi I have to specify in a table certain values for:
    >: Minutes duration spent on phone-eventduration, the
    >: eventdate-which date, and event time- exact time
    >: I was wondering in your opinon which are the best data
    >: types to use for these values
    > --- Microsoft CDO for Windows 2000
    >
    >
    >.
    >
    shau Guest

Similar Threads

  1. MSAccess query : detect data type
    By Conti in forum Coldfusion Database Access
    Replies: 3
    Last Post: July 29th, 09:57 PM
  2. long query time, oracle clob data type
    By JohnAbbott in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: July 6th, 09:17 PM
  3. 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
  4. Converting data type varchar to data type money
    By schaudry in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 10th, 07:22 PM
  5. Replies: 1
    Last Post: May 31st, 08:56 PM

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