Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    47

    Unanswered: how to create table to accept date in sql 2005 ?

    i m trying to create a table in ms sql 2005 to accept and date
    i m using this syntax but my sql server is not accepting date as a datatype
    y can you say ?
    syntax :
    Code:
    create table info9a(dob date)

  2. #2
    Join Date
    Sep 2011
    Posts
    31
    DATE data type was introduced in SQL Server 2008. Use DateTime data type in SQL Server 2005.

  3. #3
    Join Date
    Sep 2011
    Posts
    71
    Quote Originally Posted by cindyaz View Post
    DATE data type was introduced in SQL Server 2008. Use DateTime data type in SQL Server 2005.
    Yes ,Cindayaz
    Sql 2005 not support data as a datatype
    So you can use DateTime instead it

    try!!!
    and tell me the result

Posting Permissions

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