error 22007 derby
Error Derby p this post in threaded view diams diams relatedl Report Content as Inappropriate diams diams Date - Timestamp format for inserts Hi I can't figure this out I'm getting an error that says 'The syntax of the string representation of a datetime value is incorrect ' I've tried or different formats It doesn't seem to like anything The only fields that are Date fields are DateCreated and DateExpired They're taken from a MySql DATETIME datatype but I'm not sure what they convert to in Derby What's wrong with this statement INSERT INTO users RecordID CTMCClientID OrgName Prefix FName
error 22007
Error table id toc tbody tr td div id toctitle Contents div ul li a href Error Invalid Input Syntax For Type Timestamp a li li a href Error a li li a href Sqlstate Db a li ul td tr tbody table p that make connections all over the world Join today Download Extend Drupal relatedl Core Distributions Modules Themes DateIssues SQLSTATE Invalid datetime error sql server format ActiveProject DateVersion x- Component Date FieldPriority MajorCategory Bug reportAssigned UnassignedReporter e goriCreated June - Updated June - p h id Error Invalid Input Syntax For Type Timestamp p Log in or