display dd/MM/yyy format using label in asp.net C#

Question

0.00/5 (No votes)

See more:

hi frnds,

am working on asp.net c#.

I want to display date using label.

presently am display like this 6/22/2013 5:15:38 pm

So i need like this 22/6/2013 5:15:38 pm

this is my code.................

lblDateTime.Text = reader[7].ToString();

Please help thanks in advance.

Posted 22-Jun-13 1:48am

Member239258

Updated 12-Nov-17 22:28pm

Add a Solution

5 solutions

Solution 4

Try This ...:)

C#

lblDate.Text=Convert.ToDateTime(DateVariable).ToString("dd/MM/yyyy");

Posted 25-Jun-13 4:38am

Nirav Prabtani

v2

Solution 5

You can also convert in procedure like

convert(datetime,FieldName) as FieldName

Thanks

Posted 25-Jun-13 18:18pm

Rashmikants Monpara

Comments

CHill60 26-Jun-13 8:55am

That will only work if the OPs "reader" is for something that supports tSql

[no name] 26-Jun-13 23:43pm

Try this

select convert(varchar,getdate(),113)
select convert(varchar,getdate(),103)

Solution 1

Use String.Format("DD/MM/YYYY")

Posted 22-Jun-13 1:57am

Anupam Singh

v2

Solution 3

Try this :

C#

lbl.Text = Convert.ToDateTime(YourDateVariable).ToString("dd/MM/yyyy");

Posted 22-Jun-13 2:35am

Dineshshp

Comments

Ron Beyer 22-Jun-13 8:39am

If the value in the column is DbNull, this will cause an exception. ProgramFox's is the most elegant, otherwise you also need to check for DB null and that the type is convertible to a DateTime before attempting the conversion.

Dineshshp 22-Jun-13 8:56am

I Know very well & providing only solution for this problem. Error tracking is responsibility of programmer not helper...

Ron Beyer 22-Jun-13 9:43am

So you assume that somebody who doesn't know how to format a date knows how to correctly handle DbNull and type conversion checking? Its at least worth mentioning by the "helper" that the code above can throw errors in common situations...

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)

Thomas Daniels · Accepted Answer · 2013-06-22T02:00:00

Solution 2

Hi,

Try:

C#

if (reader[7] is DateTime)
{
lblDateTime.Text = (reader[7] as DateTime).ToString("dd/MM/yyyy h:mm:ss tt");
}
else
{
    // reader[7] isn't a DateTime
}

Hope this helps.

Posted 22-Jun-13 2:00am

Thomas Daniels

Comments

Ron Beyer 22-Jun-13 8:39am

+5

Thomas Daniels 22-Jun-13 8:54am

Thank you!

Tiwari Avinash 26-Jun-13 2:04am

MY 5 sir ProgramFOX!!

Thomas Daniels 26-Jun-13 2:12am

Thank you!