如何在asp.net中将字符串转换为smalldatetime？ [英] how to convert string to smalldatetime in asp.net?

问题描述

此查询在sql中排除但在asp.net中没有优先权

this query excecuting in sql but not excecuting in asp.net

"SELECT DISTINCT tbl_PT_ModelPrize.DATE, CONVERT(CHAR(4), tbl_PT_ModelPrize.DATE, 100) + CONVERT(CHAR(4), tbl_PT_ModelPrize.DATE, 120) AS date"
                                  +"FROM tbl_PT_ModelPrize INNER JOIN tbl_PT_ModelMaster ON tbl_PT_ModelPrize.MODEL_NAME = tbl_PT_ModelMaster.MODEL_NAME where"+
"  tbl_PT_ModelPrize.MODEL_NAME = tbl_PT_ModelMaster.MODEL_NAME";

问题是字符串转换失败到smalldatetime

the problem is conversion failed in string to smalldatetime

推荐答案

尝试

CAST(ModelPrize As SmallDateTime)

。

使用CAST或CONVERT语句，检查以下链接



CAST和CONVERT（Transact-SQL） [ ^ ]

TSQL Cast Vs转换 [ ^ ]

CAST AND CONVERT（T-SQL） [ ^ ]



问候，

GVprabu

Hi,

Use CAST or CONVERT Statements, Check the following links

CAST and CONVERT (Transact-SQL)[^]
TSQL Cast Vs Convert[^]
CAST and CONVERT (T-SQL)[^]

Regards,
GVprabu

这篇关于如何在asp.net中将字符串转换为smalldatetime？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！