如何从mm / dd / yyyy转换为dd / mm / yyyy格式...任何人都帮我请 [英] how to convert in to dd/mm/yyyy format from mm/dd/yyyy...anyone help me please
本文介绍了如何从mm / dd / yyyy转换为dd / mm / yyyy格式...任何人都帮我请的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
以下是我的代码...
public DataSet Admininformsale()
{
尝试
{
SetConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = 选择类别,Compname ,TDiscount,City,Area,Venid,DetailsOfDiscount,Emailid,Convert(char(8),SDate,10)as SDate,Convert(char(8),EDate,10)asate from offsale.OS_Informsale where Approval ='False'和datediff(day,EDate,getdate())< = 0按类别排序;
da = new SqlDataAdapter(CommandText,sql_con);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
catch (例外情况)
{
return null ;
}
private DataTable AdminInformshow()
{
// SqlConnection sql_con;
My_Util Util = new My_Util();
尝试
{
// string CommandText;
SqlCommand sql_cmd;
SqlDataAdapter da;
Util.SetConnection();
sql_cmd = Util.sql_con.CreateCommand();
string CommandText = 选择类别,Compname ,TDiscount,City,Area,Venid,DetailsOfDiscount,Emailid,CONVERT(CHAR(8),SDate,10)作为SDate,CONVERT(CHAR(8),EDate,10)作为来自offsale.OS_Informsale的EDate,其中Approval ='False'和datediff(day,EDate,getdate())< = 0按类别排序;
da = new SqlDataAdapter(CommandText,Util.sql_con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
catch (例外情况)
{
return null ;
}
}
解决方案
CONVERT(varchar(10),EDate,103)
应将日期转换为您要查找的格式。请参阅 http://msdn.microsoft.com/en-us/library/ms187928.aspx [ ^ ]了解更多详情。
following is my code...
public DataSet Admininformsale()
{
try
{
SetConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "select Category,Compname,TDiscount,City,Area,Venue,DetailsOfDiscount,Emailid,Convert(char(8),SDate,10)as SDate,Convert(char(8),EDate,10) as EDate from offsale.OS_Informsale where Approval='False' and datediff(day,EDate,getdate())<=0 order by Category";
da = new SqlDataAdapter(CommandText, sql_con);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
catch (Exception ex)
{
return null;
}
private DataTable AdminInformshow()
{
//SqlConnection sql_con;
My_Util Util = new My_Util();
try
{
// string CommandText;
SqlCommand sql_cmd;
SqlDataAdapter da;
Util.SetConnection();
sql_cmd = Util.sql_con.CreateCommand();
string CommandText = "select Category,Compname,TDiscount,City,Area,Venue,DetailsOfDiscount,Emailid,CONVERT(CHAR(8),SDate,10)as SDate,CONVERT(CHAR(8),EDate,10) as EDate from offsale.OS_Informsale where Approval='False' and datediff(day,EDate,getdate())<=0 order by Category";
da = new SqlDataAdapter(CommandText, Util.sql_con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
catch (Exception ex)
{
return null;
}
}
解决方案
CONVERT(varchar(10), EDate, 103)
should convert date to the format you are looking for. See http://msdn.microsoft.com/en-us/library/ms187928.aspx[^] for more details.
这篇关于如何从mm / dd / yyyy转换为dd / mm / yyyy格式...任何人都帮我请的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文