一个关于T-SQL的问题# Database - 数据库
B*a
1 楼
Need to convert a varchar column to datetime format.
The column is like:
monthid
200811
200711
200610
200510
I need them to be like
2008/11/15
2007/11/15
2006/10/15
2005/10/15
i.e., convert it to the 15th date of the month...how can I do this in T-SQL?
thanks a lot!!!
The column is like:
monthid
200811
200711
200610
200510
I need them to be like
2008/11/15
2007/11/15
2006/10/15
2005/10/15
i.e., convert it to the 15th date of the month...how can I do this in T-SQL?
thanks a lot!!!