将datetime转换为smalldatetime [英] convert datetime to smalldatetime
问题描述
这是下面的例子
插入[testBIAS]([EFFECTIVE_TIMESTAMP])
insert into [testBIAS]([EFFECTIVE_TIMESTAMP])
选择tempbias中的EFFECTIVE_TIMESTAMP
select EFFECTIVE_TIMESTAMP from tempbias
model-2
选择CONVERT(char(20),EFFECTIVE_TIMESTAMP,121)来自tempbias
select CONVERT(char(20), EFFECTIVE_TIMESTAMP,121) from tempbias
此处插入语句列为smalldatetime,而selec语句列中为datetime.
here insert statement column is smalldatetime where as in the selec statement column is datetime.
如何运行此查询.
推荐答案
你好,
谢谢您的发帖!我建议将您的问题发布在SQL Server开发人员中心之一中. SQL Server论坛> Transact-SQL位于此处:
Thank you for your post! I would suggest posting your question in one of the SQL Server Developer Center > SQL Server Forums > Transact-SQL located here:
http://social.msdn.microsoft.com/Forums/en-US/transactsql /threads
希望这对您有所帮助.
祝你有美好的一天!
Dinesh
第2层应用程序支持
服务器和工具在线运营团队
Dinesh
Tier 2 Application Support
Server and Tools Online Operations Team
这篇关于将datetime转换为smalldatetime的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!