"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";
CAST(ModelPrize As SmallDateTime)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)