How to insert yyyy-yyyy date format in MySQL database via VB.NET -

How to insert yyyy-yyyy date format in MySQL database via VB.NET -

i can insert date format yyyy in database datatype of year(4) vb.net code:

sql = "insert tblyear(year) values(now())"

i'm planning insert this year - next year, phone call school year.

i agree @daniel, should store current year , have display code format things way want. if need works:

sql = "insert tblyear(year) values (concat(year(now()),'-',(year(now()) + 1)))"

mysql vb.net