How to convert '31/12/2016' Date Format in SQL?

Question

Please help with this problem,
Thank You...

Answer 1

Convert for what?
you can use 'date' datatype to insert Date in your tables..
or use varchar in place of it.

Answer 2

convert(date,(date_kolom),112)

Answer 3

I am saving data using VB.Net datetimepicker.value to pass to the insert statement of the sql, the returns me a convertion error from string type to date type.

Answer 4

I don´t know if you´ve already got your answer...
In SQL you write the date like this: '2016-12-31'