1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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

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

0
  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,764
    Likes Received:
    13
    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