What is the correct way of inserting a DATE in to a database?

Discussion in 'Databases' started by nvidura, Aug 3, 2006.

  1. #1
    When i try to execute the above code it says

    Server: Msg 2715, Level 16, State 7, Line 4
    Column or parameter #5: Cannot find data type date.

    Please help me with this.

    Thanks
     
    nvidura, Aug 3, 2006 IP
  2. danielbruzual

    danielbruzual Active Member

    Messages:
    906
    Likes Received:
    57
    Best Answers:
    0
    Trophy Points:
    70
    #2
    danielbruzual, Aug 3, 2006 IP
  3. nvidura

    nvidura Well-Known Member

    Messages:
    1,780
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    #3
    Thanks
    I've change the "date" datatype with "datetime"
    it was a syntax error.
     
    nvidura, Aug 3, 2006 IP