0

Hi guyz,
My problem is when i am saving a record in MySQL Database there is an error occured

"Incorrect datatime value 3/20/2011 for COLUMN DATE at ROW 1"

I used Date as my DataType in MySQL server?

Can anyone fix my error ??

3
Contributors
3
Replies
7
Views
6 Years
Discussion Span
Last Post by swayzion
0

how ur passing the date from Front end? as a datetime ? or string?
Whats ur DB datatype for that column???

0

i used DATE as my datatype on MySql DB

its done and i use these code

Format(CType(Me.DateTimePicker1.Text, DateTime), "yyy-MM-dd") & "','" & _
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.