MySQL and ASP.NET (vb) issue with TIME automatically being added to DATE field

Question

I'm having a problem with a MySQL query for returning the "last visit" field in a table.

Originally I had:

select fname, lname, last_visit from patient where isactive = 1 and uid = 1

Which worked perfectly in MySQL, but as soon as the query is executed by my ASP.NET app, it adds in the time field also to the date area. So 2011-12-12 becomes 12/12/2011 12:00:00 AM

I tried this also, with no improvement:

select fname, lname, DATE(last_visit) as last_visit from patient where isactive = 1 and uid = 1 order by lname

How can I fix this?

Are you storing this date in a DateTime object?

Stefan H
– Stefan H

2012-03-13 19:26:01 +00:00
Commented Mar 13, 2012 at 19:26 — Stefan H
– Stefan H, Commented Mar 13, 2012 at 19:26
I mean in VB.net, what data type is it being stored into?

Stefan H
– Stefan H

2012-03-13 19:31:29 +00:00
Commented Mar 13, 2012 at 19:31 — Stefan H
– Stefan H, Commented Mar 13, 2012 at 19:31

Meta-Knight · Accepted Answer · 2012-03-13 19:34:19Z

2

A .NET DateTime object always has a Time component. In your app, you can just ignore it though.

Dim myDate As New DateTime(2011,12,12)

Dim dateAndTime As String = myDate.ToString() 'Prints 12/12/2011 12:00:00 AM

Dim onlyDate As String = myDate.ToShortDateString() 'Prints 12/12/2011

edited Mar 13, 2012 at 19:34

answered Mar 13, 2012 at 19:27

Meta-Knight

17.9k1 gold badge51 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Trio · Accepted Answer · 2012-03-13 19:28:37Z

0

MySql will add the time by default if its a datetime field. Try implementing a custom date and time format string. MSDN article about custom date/time formats

answered Mar 13, 2012 at 19:28

Trio

1764 bronze badges

Collectives™ on Stack Overflow

MySQL and ASP.NET (vb) issue with TIME automatically being added to DATE field

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related