Results 1 to 2 of 2

Thread: sql server 2005 question

  1. #1
    Join Date
    Mar 2007
    Posts
    2

    sql server 2005 question

    hey i have used oracle 9i. Am a beginner in msql server 2005. I find some data type issues difficult. Very easy question what is the correct data type for 'YEAR' in msql server. I understand that i can use smalldate data type for date.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    There is no such data type in sql, you can get year with datepart function like datepart(yy, date_column).

Posting Permissions

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