Leaving out the YEAR in the datetime data type in sql

[lolwtf]

I have a datagridview that tracks when employees clock in and out. I used the datetime data type in sql but I dont want the year to display. How would i go about doing this? Do i have to modify my select statement, or can I do it with vb code?

Thanks in advance

[sknake]

You should be able to set a format string for the column in the grid. Here are the formats you can define:
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx

[lolwtf]

Thats sort of what im looking for. I have this so far:
DGVTime.Columns("InOuTime").

InOutTime is my variable in sql but im stuck at this part.

[eloelo22]

try using these example textbox1.text = (cell of the grid).tostring("hh:mm:ss") just give it a try

[kvprajapati]

Here is sample:

Dim col1 As New DataGridViewTextBoxColumn
        col1.DefaultCellStyle.Format = "t" 'Time format
        col1.DataPropertyName = "ColumnName"

        DataGridView1.Columns.Add(col1)
        DataGridView1.DataSource = dt  'Instance of DataTable

[lolwtf]

adatapost's code worked. Thanks guys!