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 ??
bestex
0
Newbie Poster
Recommended Answers
Jump to Posthow ur passing the date from Front end? as a datetime ? or string?
Whats ur DB datatype for that column???
All 3 Replies
Pgmer
50
Master Poster
Featured Poster
how ur passing the date from Front end? as a datetime ? or string?
Whats ur DB datatype for that column???
bestex
0
Newbie Poster
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") & "','" & _
swayzion
0
Newbie Poster
Would love to have the solution for this as I am in the same situation!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.