DateTime字符串分隔 [英] DateTime string separation
问题描述
有人可以建议以下解决方案吗?
在sql table列中，我将字段定义为DATETIME.
在检索我只想约会的时候.
我的项目在ASP.net中，C#；
我正在网格中显示数据.
公共数据表load_Project()
{
DataTable dtTower = new DataTable();
字符串sql =从tbl_Project中选择projName";
SqlCommand cmd =新的SqlCommand(sql，con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda =新的SqlDataAdapter(cmd);
sda.Fill(dtTower);
返回dtTower;
}
can anybody suggest any solution for the below:
In sql table column, I defined a field as DATETIME.
while retrieving I want on only date.
And my project is in ASP.net, C#;
And I am displaying data in grid.
public DataTable load_Project()
{
DataTable dtTower = new DataTable();
string sql = "select projName from tbl_Project";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dtTower);
return dtTower;
}
推荐答案
从tbl_Project中选择projName，CONVERT(VARCHAR(10)，GETDATE()，103)
代替GETDATE()，您可以放置日期时间字段名称.
它将以dd/mm/yyyy格式给出日期.
Minal Shah.
select projName,CONVERT(VARCHAR(10),GETDATE() ,103) from tbl_Project
in place of GETDATE() you can put your datetime field name.
it will give a date in dd/mm/yyyy format.
Minal Shah.
只需将您的DateTime字段放入CSharp的DateTime类中，然后
您可以使用其函数ToDateString()仅获取日期.
您可以在网格的行数据绑定事件时执行此操作.
请参阅以下链接以获取sql server和ado.net数据类型的映射.
http://msdn.microsoft.com/en-us/library/cc716729.aspx [ ^ ]
希望这会有所帮助！
Just take your DateTime field into DateTime Class of CSharp and then
you can use it''s function ToDateString() to get only date.
You can do this at the time of rowdata bound event of grid.
Refer following link for mapping of sql server and ado.net data types.
http://msdn.microsoft.com/en-us/library/cc716729.aspx[^]
Hope this will help!
字符串sql =从tbl_Project中选择projName";
string sql = "select projName from tbl_Project";
将您的SQL查询更改为
select projName, convert(varchar,dateField,101) from tbl_Project
(其中dateField是您在数据库中的日期字段).
101将以mm/dd/yyyy格式返回您的日期，但还有其他可用格式(请查看msdn上的Convert关键字以获取其他格式).
Change your sql query to
select projName, convert(varchar,dateField,101) from tbl_Project
(where dateField is your date field in the database).
101 will return your date in mm/dd/yyyy format but there are other formats available as well (check out the Convert keyword on msdn for other formats).
这篇关于DateTime字符串分隔的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
