Skip to main content

How To Separate Date & Time For DateTime Format In SQL2005 With VB.Net

I'm sure few people just like i did a few hours ago. i have a problem when having a code and debugging an application in VB.Net. 

case :
i want to show data in datagridview from a database with field using DateTime type. but sure it was confused me, how to show data for only the time not include the date (sample, 13:30:00). as datetime format is should always shows (29/07/2013 13:30:00).

then after fighting  couple hours finally i get this code. so i hope it can solve if one of you having same trouble as i did...

DTA = New SqlDataAdapter("SELECT IdMaintenance, IdMesin, IdSistemUser, IdSimpulMasalah, " & _
                                     "IdSeksi, Convert(Varchar,JamMulai,101) as Mulai, " & _
                                     "Convert(Varchar,JamMulai,108) as JMulai, " & _
                                     "Convert(Varchar,JamSelesai,101) as Selesai, " & _
                                     "Convert(Varchar,JamSelesai,108) as JSelesai, " & _
                                     "InformasiMain, PenyebabMain, PerbaikanMain, TindakanMain, PesanMain " & _
                                     "FROM MaintenanceTabel ORDER BY IdMaintenance ASC", MeKONEKSI.BUKAKONEKSI)


pay more attention to codes :

Convert(Varchar,JamMulai,101) as Mulai
above code is to show only DATE data from field name JamMulai (29/07/2013)

Convert(Varchar,JamMulai,108) as JMulai
above code is to show only TIME data from field name JamMulai (13:30:00)

Comments

Popular posts from this blog

Pop Up message Visual Studio "The operation could not be completed. The process cannot access the file because it is being used by another process"

Run your Visual Studio as Administrator account

Create Comment As .xls In Farpoint Spread

  Private Sub TAGS_PARENTING()         Dim DTPopUp As New DataTable         With DTPopUp             .Columns.Add("SEQ", GetType(String))             .Columns.Add("QTY", GetType(String))             .Columns.Add("ETD", GetType(String))             .Columns.Add("ETA", GetType(String))             DTPopUp = MePostab_Control.Cari_TAG_PARENTING         End With         With FPPOSTAB             For GG As Integer = 0 To .ActiveSheet.RowCount - 1             ...