jingju11 发表于 2012-5-15 09:00 
如果是date值,用YEAR()获取年份。在这里你应该不关心具体的日期。其实我或许不是非常理解你的问题。京剧
Ok, I'd like to reinterate my question.
Here, when I read column "year" such as 2003, 2004......., the default is number format. My question is how to transform variable "year" into date format, at the same time, looks like 2003, 2004 but the format is date? Many thanks