如何把这列的内容分成两列内容?
我有一个表,其中一列的内容是这样子的:
rqsj
2004-05-01 15:32:52.077
2004-05-01 15:36:43.950
2004-05-01 15:50:51.437
2004-05-01 16:32:16.810
2004-05-01 17:41:59.390
2004-05-01 18:48:41.950
2004-05-01 19:14:19.890
2004-05-01 19:16:31.357
我现在想要分成两列内容:
rq sj
2004-05-01 15:32:52.077
2004-05-01 15:36:43.950
2004-05-01 15:50:51.437
2004-05-01 16:32:16.810
2004-05-01 17:41:59.390
2004-05-01 18:48:41.950
2004-05-01 19:14:19.890
2004-05-01 19:16:31.357
我该怎么写SQL语句.
问题点数：20、回复次数：2Top
1 楼zjcxc（邹建）回复于 2004-05-03 14:37:06 得分 20
select rq=convert(char(10),rqsj,120),sj=convert(varchar,rqsj,108)
from 表Top
2 楼love16（一块钱）回复于 2004-05-03 18:10:16 得分 0
谢谢建哥,以后多多帮忙.
Top
