Date Formats of Date in Database

[Martin Eyles]

Hi,
I am trying to extract a date from a database, and display it in
yyyy-mm-dd hh:mm:ss format on an ASP.NET webpage. I have been using the CStr
function to turn this into text, but this doesn't give me enough control to
get the right date format. Can anyone suggest a solution?

Thanks,
Martin
'Snippet of Code I Tried
SQL = ("SELECT " & aDateTime)
anSQLCommand = New System.Data.SqlClient.SqlCommand
anSQLCommand.Connection() = conn
anSQLCommand.CommandText = SQL
R = anSQLCommand.ExecuteReader
While R.Read
displayADateTime = CStr(R(0))
End While

[Maarten]

R(0).ToString("yyyy-mm-dd")

"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

Hi,
I am trying to extract a date from a database, and display it in
yyyy-mm-dd hh:mm:ss format on an ASP.NET webpage. I have been using the
CStr function to turn this into text, but this doesn't give me enough
control to get the right date format. Can anyone suggest a solution?

Thanks,
Martin
'Snippet of Code I Tried
SQL = ("SELECT " & aDateTime)
anSQLCommand = New System.Data.SqlClient.SqlCommand
anSQLCommand.Connection() = conn
anSQLCommand.CommandText = SQL
R = anSQLCommand.ExecuteReader
While R.Read
displayADateTime = CStr(R(0))
End While

[Martin Eyles]

"Maarten" <No****@me.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...

R(0).ToString("yyyy-mm-dd")
This gives a compiler error - path\filename.ascx.vb(line): 'Public
Overridable Function ToString() As String' has no parameters and its return
type cannot be indexed.

Any more ideas?

Thanks,
Martin

"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

Hi,
I am trying to extract a date from a database, and display it in
yyyy-mm-dd hh:mm:ss format on an ASP.NET webpage. I have been using the
CStr function to turn this into text, but this doesn't give me enough
control to get the right date format. Can anyone suggest a solution?

Thanks,
Martin
'Snippet of Code I Tried
SQL = ("SELECT " & aDateTime)
anSQLCommand = New System.Data.SqlClient.SqlCommand
anSQLCommand.Connection() = conn
anSQLCommand.CommandText = SQL
R = anSQLCommand.ExecuteReader
While R.Read
displayADateTime = CStr(R(0))
End While

[Pipo]

Sure...

Dim strDate as string = R(0).ToString()
strDate = strDate.ToString("mm-yyyy-dd")
"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

"Maarten" <No****@me.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...

R(0).ToString("yyyy-mm-dd")

This gives a compiler error - path\filename.ascx.vb(line): 'Public
Overridable Function ToString() As String' has no parameters and its
return type cannot be indexed.

Any more ideas?

Thanks,
Martin

"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

Hi,
I am trying to extract a date from a database, and display it in
yyyy-mm-dd hh:mm:ss format on an ASP.NET webpage. I have been using the
CStr function to turn this into text, but this doesn't give me enough
control to get the right date format. Can anyone suggest a solution?

Thanks,
Martin
'Snippet of Code I Tried
SQL = ("SELECT " & aDateTime)
anSQLCommand = New System.Data.SqlClient.SqlCommand
anSQLCommand.Connection() = conn
anSQLCommand.CommandText = SQL
R = anSQLCommand.ExecuteReader
While R.Read
displayADateTime = CStr(R(0))
End While

[Pipo]

But that's also not the good one ;->

Here is 1:
DateTime dte;
if (DateTime.TryParse(R[0].ToString(), out dte))
{
string strDate = dte.ToString("MM-yyyy-dd");
}
"Pipo" <Pa****@Mayo.com> wrote in message
news:uh**************@tk2msftngp13.phx.gbl...

Sure...

Dim strDate as string = R(0).ToString()
strDate = strDate.ToString("mm-yyyy-dd")
"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

"Maarten" <No****@me.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...

R(0).ToString("yyyy-mm-dd")

This gives a compiler error - path\filename.ascx.vb(line): 'Public
Overridable Function ToString() As String' has no parameters and its
return type cannot be indexed.

Any more ideas?

Thanks,
Martin

"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...
Hi,
I am trying to extract a date from a database, and display it in
yyyy-mm-dd hh:mm:ss format on an ASP.NET webpage. I have been using the
CStr function to turn this into text, but this doesn't give me enough
control to get the right date format. Can anyone suggest a solution?

Thanks,
Martin
'Snippet of Code I Tried
SQL = ("SELECT " & aDateTime)
anSQLCommand = New System.Data.SqlClient.SqlCommand
anSQLCommand.Connection() = conn
anSQLCommand.CommandText = SQL
R = anSQLCommand.ExecuteReader
While R.Read
displayADateTime = CStr(R(0))
End While

[Martin Eyles]

"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

"Maarten" <No****@me.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...

R(0).ToString("yyyy-mm-dd")
This gives a compiler error - path\filename.ascx.vb(line): 'Public
Overridable Function ToString() As String' has no parameters and its
return type cannot be indexed.

Any more ideas?

It's OK, have fixed the above suggestion, by converting to date before
converting to string - I think it is awkward because the value comes from
the database. The code I use is:-
CDate(R(0)).ToString("yyyy-MM-dd HH:mm:ss")
Thanks again to everyone for their help,

Martin
Thanks,
Martin

"Martin Eyles" <ma**********@NOSPAMbytronic.com> wrote in message
news:12*************@corp.supernews.com...

Hi,
I am trying to extract a date from a database, and display it in
yyyy-mm-dd hh:mm:ss format on an ASP.NET webpage. I have been using the
CStr function to turn this into text, but this doesn't give me enough
control to get the right date format. Can anyone suggest a solution?

Thanks,
Martin
'Snippet of Code I Tried
SQL = ("SELECT " & aDateTime)
anSQLCommand = New System.Data.SqlClient.SqlCommand
anSQLCommand.Connection() = conn
anSQLCommand.CommandText = SQL
R = anSQLCommand.ExecuteReader
While R.Read
displayADateTime = CStr(R(0))
End While