- cloud123
-
不用转换类型 直接用字符串 系统会默认转换的
insert into [ORIENT_TRADE].[dbo].[TRD_MEMBER_MESSAGE](
[MessageSubject]
,[MessageContent]
,[MessageObjectType]
,[MessageObjectId]
,[ReceiverMember]
,[ReceiverContactPerson]
,[SenderMember]
,[SenderContactPerson]
,[MessageIp]
,[MessageOrigin]
,[CreateDateTime]
,[ReadFlag]
,[ReplyFlag]
,[ReplyDateTime]
,[ReplyMessagePKId]
,[SpamFlag]
,[ReceiverDeleteFlag]
,[SenderDeleteFlag]
,[MessageType]) values ("mS","Mc",1,NULL,1000210,870000147,1000204,870000137,"10.0.0.1","CN","2011-08-26 14:26:12.000" ,0,0,"NULL",66,0,0,0,0)
- 小教板
-
cast("2011-08-26 14:26:12.000" As datetime),
换成这个
to_date("2011-08-26 14:26","yyyy-mm-dd hh24:mm")