to_char(CREATETIME,'YYYYMMDD')--to_char显示时间格式小例子

select t.SERVICECODE,b.usernumber,to_char(b.CREATETIME,'YYYYMMDD'),20060401,b.usernumber from game.usertailor b,sms.spservicetypect  t ,game.tailorservice n where n.seq=b.SERVICE and n.ERSERVICENO=t.SERVICENO
posted @ 2006-03-27 13:03  城市里的鱼  阅读(1895)  评论(0)    收藏  举报