sql 中英文格式的时间转数字格式


select receiveBillDt,CONVERT(varchar(100), cast(receiveBillDt as datetime), 21),a.LoanDate from ProtocolInfo a where a.receiveBillDt is not null

posted @ 2015-08-28 16:36  秋香姑娘请你不要紧张  阅读(941)  评论(0编辑  收藏  举报