-
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.
-
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
-
Forum Rules
|
|