how to convert datetime datatype to string in asp.net + vb

Question

I want to convert datetime to string. I have declared DATE_PLACED_IN_SERVICE as datetime in SQL server database and want to convert it to string in my source code. I am getting the error: "Unable to cast object of type 'System.DateTime' to type 'System.String'"

Here my source code:

If rdmysql.IsDBNull(rdmysql.GetOrdinal("DATE_PLACED_IN_SERVICE")) = False Then
    Dim ServiceDate As Date = rdmysql.GetString(rdmysql.GetOrdinal("DATE_PLACED_IN_SERVICE"))
    ServiceTxt.Text = Format(ServiceDate, "yyyy-MM-dd")
End If

Tim Schmelter · Accepted Answer · 2018-05-11 09:39:05Z

1

This column is of type datetime, so you cant use GetString but GetDateTime:

Dim ServiceDate As Date = rdmysql.GetDateTime(rdmysql.GetOrdinal("DATE_PLACED_IN_SERVICE"))

Instead of the VB6 Format function i would use .NET:

ServiceTxt.Text = ServiceDate.ToString("yyyy-MM-dd")

or simple and readable (if your culture uses - as date delimiter):

ServiceTxt.Text = ServiceDate.ToShortDateString()

answered May 11, 2018 at 9:39

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

1 Comment

Tim Schmelter Over a year ago

@hasni: you're welcome. Remember to accept if your question is solved.

Collectives™ on Stack Overflow

how to convert datetime datatype to string in asp.net + vb

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related