“If we mean to have heroes, statesmen and philosophers, we should have learned women.” Abigail Adams said. She was born in December 22nd, 3 days before Christmas in 1744. I was trying to insert her date of birth in to MSSQL DataTime field, something like insert in to firstlady(dateofbirth) values({d '1744-12-22'})and it gave the error “[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting datetime from character string.”.
(more..)