VB.NET

VB.NET RSS

dispaly date only in vb.net

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: May 2009

Posts: 3

Reputation: sunil01 is an unknown quantity at this point

Solved Threads: 0

sunil01

Offline

Newbie Poster

dispaly date only in vb.net

May 15th, 2009

Guys please help me out on ths'
I have created a table in sql ' managed to change datetime to date only in (sql query analyzer ' parsed it ) its shown date only n sql table but its shown both datetime in vb.net textbox Please tell me if my method is right or gve me the correct method.
I will be really thankful. U can even e mail me direct on my e mail
sunilgill2007@hotmail.com

•

Join Date: Aug 2008

Posts: 710

Reputation: Teme64 will become famous soon enough

Solved Threads: 114

Teme64

Offline

Master Poster

Re: dispaly date only in vb.net

May 15th, 2009

Use ToShortDateString of the DateTime class. Here's an example

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim SQLDateTime As Date
Dim OnlyDate As String
 
' Debug, get this value from SQL Server. Notice: This is my locale date format
SQLDateTime = CDate("15.5.2009 15:53:00")
OnlyDate = SQLDateTime.ToShortDateString
 
MessageBox.Show(OnlyDate, "Only Date", MessageBoxButtons.OK, MessageBoxIcon.Information)
Dim SQLDateTime As Date
Dim OnlyDate As String

' Debug, get this value from SQL Server. Notice: This is my locale date format
SQLDateTime = CDate("15.5.2009 15:53:00")
OnlyDate = SQLDateTime.ToShortDateString

MessageBox.Show(OnlyDate, "Only Date", MessageBoxButtons.OK, MessageBoxIcon.Information)

Teme64 @ Windows Developer Blog

•

Join Date: Aug 2008

Posts: 710

Reputation: Teme64 will become famous soon enough

Solved Threads: 114

Teme64

Offline

Master Poster

Re: dispaly date only in vb.net

May 21st, 2009

Here's another way to do it

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim SQLDateTime As Date
Dim OnlyDate As String
Dim TempPos As Integer
 
' Debug, get this value from SQL Server. Notice: This is my locale date format
SQLDateTime = CDate("21.5.2009 10:36:00")
' Locate the space character. That should be a separator between the date and the time parts
TempPos = SQLDateTime.ToString.IndexOf(" ")
If TempPos >= 0 Then
  OnlyDate = SQLDateTime.ToString.Substring(0, TempPos)
Else
  OnlyDate = "Invalid date"
End If
 
MessageBox.Show(OnlyDate, "Only Date", MessageBoxButtons.OK, MessageBoxIcon.Information)
Dim SQLDateTime As Date
Dim OnlyDate As String
Dim TempPos As Integer

' Debug, get this value from SQL Server. Notice: This is my locale date format
SQLDateTime = CDate("21.5.2009 10:36:00")
' Locate the space character. That should be a separator between the date and the time parts
TempPos = SQLDateTime.ToString.IndexOf(" ")
If TempPos >= 0 Then
  OnlyDate = SQLDateTime.ToString.Substring(0, TempPos)
Else
  OnlyDate = "Invalid date"
End If

MessageBox.Show(OnlyDate, "Only Date", MessageBoxButtons.OK, MessageBoxIcon.Information)

If you still can't get the date part only, show the original datetime value read from DB.