Convert SQL date datatype to string

Question

I am writing something in VB and need to convert a SQL date (not datetime) into a string. This should be an easy convertion, however toString does not work and I cannot find anything online . The part of the code I'm working on looks like this:

    Dim incomingDate As String
    incomingDate = row.Cells(5).Text.ToString()

When the data being put in the gridview is a DateTime datatype this works fine. If it's simply Date, it gives me the following error message:

"Specified argument was out of the range of valid values. Parameter name: index"

I've also tried this work-around but it didn't work

    Dim incomingDate As String
    Dim d As New DateTime
    d = DateTime.Parse(row.Cells(5).Text)

    incomingDate = Date.Parse(row.Cells(5).Text)

Same error...

What exactly is the column type for the "date" of which you speak? Which DBMS? How are you querying for data? — Cᴏʀʏ
– Cᴏʀʏ, Commented Jul 26, 2012 at 21:30
The column type is 'date'. In all other tables it's datetime, however for this one they just used 'date' — NealR
– NealR, Commented Jul 26, 2012 at 21:37
Are you trying to read the value back out of a form control like a Table or Grid? The error you receive makes me thing that row.Cells(5) doesn't exist. Do you have six columns? Remember to index the cells starting with 0, not 1. Other than that, retrieving the text via the .Text property should be ok. No need to parse into a Date unless you want to change the format. — Cᴏʀʏ
– Cᴏʀʏ, Commented Jul 26, 2012 at 22:10

Dan Pichelman · Accepted Answer · 2012-07-26 21:33:14Z

1

In SQL you can use convert(varchar, mySqlDate, 101) to emit a string instead of a date. Is that what you had in mind?

answered Jul 26, 2012 at 21:33

Dan Pichelman

2,3422 gold badges32 silver badges44 bronze badges

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

2 Comments

NealR Over a year ago

I am running the code in Visual Studio, loading the query into a SqlDataAdapter object. Is this something I can add into the SQL SELECT statement?

Dan Pichelman Over a year ago

Yes. Instead of select mySqlDate ... (which returns a SqlDate), plug this in select convert(varchar, mySqlDate, 101) ... and get back a string instead.

Collectives™ on Stack Overflow

Convert SQL date datatype to string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related