DateTime string separation

Question

0.00/5 (No votes)

See more:

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;

}

Posted 7-May-10 20:16pm

shanawazway

Add a Solution

3 solutions

Solution 1

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!

Posted 7-May-10 20:25pm

Peace ON

Solution 2

shanawazway wrote:
string sql = "select projName from tbl_Project";

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).

Posted 7-May-10 21:11pm

Abhinav S

Updated 7-May-10 21:12pm

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shah.minal · Accepted Answer · 2010-05-07T22:15:00

Solution 3

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.

Posted 7-May-10 22:15pm

shah.minal