All Forums Database
KVB 124 posts Joined 09/12
30 Oct 2014
Invalid Time

Hi
I have a varchar field and trying to insert data like below.It's saying Invalid time.In general,varchar filed should accept alphanumeric.
 
CT DU
(
TM VARCHAR(50) CHARACTER SET LATIN CASESPECIFIC
);
INS INTO TM
SELECT '11:05:120141029110527 '
 
 

vikas_yadav 19 posts Joined 09/12
31 Oct 2014

I dont think so this can give a error.You are missing something.Can you post table ddl..??

ToddAWalter 316 posts Joined 10/11
31 Oct 2014

TM is your column name. You have to insert into DU, your table name. 

KVB 124 posts Joined 09/12
03 Nov 2014

:)   Oversight.Thank you.

You must sign in to leave a comment.