How to get Date from dateTime

Question

0.00/5 (No votes)

See more:

ASP.NET

<asp:BoundField DataField="DateofBirth" DataFormatString="{0:dd/MM/yyyy}" HeaderText="Date of Birth" />
                            <asp:boundfield datafield="DateofBirth" dataformatstring="{0:MMMM d, yyyy}" htmlencode="false" />

i am storing date from my text box to database 12/12/1987

when i papulate my grid view it display the date like this 12/12/1987 12:00:00 AM

i use above mentioned dataformatting string.

but i did not get my result

i need 12/12/1987 only, no need of time

Posted 13-Mar-13 23:21pm

prince_rumeel

Add a Solution

6 solutions

Solution 5

watch this

http://stackoverflow.com/questions/5807004/how-to-format-a-time-stamp-to-show-the-date-only-in-a-grid-view[^]

so first of all you convert in code behind .

Posted 13-Mar-13 23:43pm

kimberly wind

Comments

prince_rumeel 14-Mar-13 5:51am

bro at the time of data storing in the database it is storing 12/12/1987
but when using LinqToSQL getAll_Date method then it bind 12/12/1987 12:00:00AM in grid

public IList GetAllPatients()
{
CastroDataContext objDAL = new CastroDataContext();

var varPatients = (from cat in objDAL.Patients
where cat.IsDeleted.Equals(false)
select new
{
PatientID = this.ToInteger(cat.PatientID),
FirstName = this.ToString(cat.FirstName),
LastName = this.ToString(cat.LastName),
Gender = this.ToString((cat.Gender == "0") ? "Male" : "Female"),
DateOfBirth = this.ToString(cat.DateofBirth),
AccompaniedBy = this.ToString(cat.AccompaniedBY),
RefferedBy = this.ToString(cat.ReferredBy),
RefferalPhoneNumber = this.ToString(cat.ReferralPhoneNumber),
RefferalEmail = this.ToString(cat.ReferalEmail),
Race = this.ToString(cat.Race),
MaritalStatus = this.ToString(cat.MaritalStatus),
EmploymentStatus = this.ToString(cat.EmploymentStatus),
Address1 = this.ToString(cat.Address1),
Address2 = this.ToString(cat.Address2),
City = this.ToString(cat.City),
State = this.ToString(cat.State),
ZipCode = this.ToInteger(cat.ZipCode),
PatientPrimaryPhone = this.ToInteger(cat.PatientPrimaryPhone),
PatientSecoundaryPhone = this.ToInteger(cat.PatientSecondaryPhone),
PatientCellNumber = this.ToInteger(cat.PatientCellNumber),
PatientOtherNumber = this.ToInteger(cat.PatientOtherNumber),
PatientPrimaryEmail = this.ToString(cat.PatientPrimaryEmail),
PatientSecoundaryEmail = this.ToString(cat.PatientSecondaryEmail),
InsuranceCompanyName = this.ToString(cat.InsuranceCompanyName),
InsuranceProviderName = this.ToString(cat.InsuranceProviderName),
InsuranceProviderType = this.ToString(cat.InsuranceProviderType),
InsuranceGroupNumber = this.ToString(cat.InsuranceGroupNumber),
InsuranceID = this.ToInteger(cat.InsuranceID),
MRN = this.ToInteger(cat.MRN),
});

return varPatients.ToList();}

this is my dal function which is getting value from database

Solution 4

make your column data type is 'date', then it will store only date..

Posted 13-Mar-13 23:37pm

vishal.shimpi

Comments

prince_rumeel 14-Mar-13 5:42am

in database column is already date
and there is date in this formate
1987-12-12

but when i get it then it look like 12/12/1987 12:00:00AM

Solution 3

Hi

Try This Query while retrieving data from database

select CONVERT(varchar(20), docdate, 103) from sales

Thanks
Shafi

Posted 13-Mar-13 23:33pm

shafi_sunshine

Comments

prince_rumeel 14-Mar-13 5:37am

I am using LinqToSQL

so no store procedure i am using

Solution 2

this may help you

http://stackoverflow.com/questions/6075754/how-can-you-show-the-date-in-a-gridview-as-a-date-only-instead-of-a-datetime[^]

Posted 13-Mar-13 23:25pm

kimberly wind

Comments

prince_rumeel 14-Mar-13 5:32am

Nothing happen

i already use that
but no gain

it is still displaying 12/12/1987 12:00:00 AM

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)

_Amy · Accepted Answer · 2013-03-14T00:16:00

Try this:

ASP.NET

<asp:boundfield datafield="DateofBirth" xmlns:asp="#unknown">
                    HeaderText="Date of Birth" 
                    SortExpression="ModifiedDate" 
                    DataFormatString="{0:d}" /></asp:boundfield>

Read BoundField.DataFormatString Property[^]

--Amit

Prasad_Kulkarni · Accepted Answer · 2013-03-13T23:45:00

Solution 6

Update your query and add this line to your date column:

SQL

SELECT CONVERT(nvarchar, GETDATE(), 101)

[Updated]
Use EntityFunctions.TruncateTime Method [^]

Also check this similar discussion: Select date from datetime[^]

Posted 13-Mar-13 23:45pm

Prasad_Kulkarni

Updated 14-Mar-13 0:02am

v3

Comments

prince_rumeel 14-Mar-13 5:55am

about which query you are talking dear

i am not using any query

Prasad_Kulkarni 14-Mar-13 5:59am

Oops my bad! Please see updated answer.

prince_rumeel 14-Mar-13 6:14am

thx man

Prasad_Kulkarni 14-Mar-13 6:16am

You're welcome!
Glad it helps.

How to get Date from dateTime

6 solutions

Solution 7

Solution 6

Solution 5

Solution 4

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us