How to retrieve only years from date time picker

[chanlichin]

Hi, I am now want to retrieve only year from my table(summary),field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as below. Thanks

If i put SELECT DATES, that means day,month and year will display. So, what should i put after SELECT

      sql = "SELECT dates FROM summary WHERE plants = '" & yieldsummary.cbPlant.Text & "'"
            da = New OleDb.OleDbDataAdapter(sql, con)
            da.Fill(ds, "summary")

            con.Close()
            maxrow = ds.Tables("summary").Rows.Count

            For x = 0 To maxrow - 1

                cbYear.Items.Add(ds.Tables("summary").Rows(x).Item("dates"))
                cbYear1.Items.Add(ds.Tables("summary").Rows(x).Item("dates"))

            Next x

 

[ajeeshco]

Hi,

You may use the YEAR or DATENAME function.
for eg,

sql = "SELECT YEAR(dates) AS [Year] FROM summary WHERE plants = '" & yieldsummary.cbPlant.Text & "'"

sql = "SELECT DATENAME(yy,dates) AS [Year] FROM summary WHERE plants = '" & yieldsummary.cbPlant.Text & "'"

Regards,
Ajeesh

 

[chanlichin]

Year can not display

Come out the error "Column 'dates' does not belong to the table summary....May i ask i need to decare anything for the date function?Thanks

 

[alander]

select * from yourTable where datepart(yyyy, dateCol) = 2007