0

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

Please help with this problem, Thank You...

17th Dec 2016, 6:11 AM
Nesty Gem Gordo
Nesty Gem Gordo - avatar
4 Réponses
+ 4
Convert for what? you can use 'date' datatype to insert Date in your tables.. or use varchar in place of it.
17th Dec 2016, 7:22 AM
Sachin Artani
Sachin Artani - avatar
0
convert(date,(date_kolom),112)
18th Dec 2016, 5:32 AM
Iman Rahmat
Iman Rahmat - avatar
0
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.
18th Dec 2016, 5:43 AM
Nesty Gem Gordo
Nesty Gem Gordo - avatar
0
I don´t know if you´ve already got your answer... In SQL you write the date like this: '2016-12-31'
30th Dec 2016, 3:45 PM
Verena