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.
Printable View
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).