Stack Overflow
Stack Overflow

Questions tagged [mysql-error-1292]

MySQL error when trying to compare numeric and non-numeric data

This is a confusing error message that comes from MySQL when a query tries to compare a numeric column with a non-numeric value. It refers to the fact that it coerces both of the values to double before doing the comparison.

If you run MySQL in non-strict mode, it will become a warning rather than an error, and the query should succeed. See MySQL Bug #46641 for some discussion of this error message.

38 questions
122
votes
10 answers

Error Code 1292 - Truncated incorrect DOUBLE value - Mysql

I am not sure what is this error! #1292 - Truncated incorrect DOUBLE value: I don't have double value field or data! I have wasted a whole hour trying to figure this out! here is my query INSERT INTO call_managment_system.contact_numbers …
Mike
  • 2,735
  • 11
  • 44
  • 68
27
votes
6 answers

error code 1292 incorrect date value mysql

I have a table `CREATE TABLE IF NOT EXISTS `PROGETTO`.`ALBERGO` ( `ID` INT(11) NOT NULL COMMENT 'identificativo dell\' albergo' , `nome` VARCHAR(45) NULL COMMENT 'Il nome dell\'albergo' , `viale` VARCHAR(45) NULL COMMENT 'Il viale in cui si trova…
FrancescoN
  • 2,146
  • 12
  • 34
  • 45
18
votes
5 answers

MySQL 1292 Incorrect datetime value

I am getting this error when I try to insert '2011/03/13 02:53:50.000000000' into a timestamp column. If I change the 13 to a 15, 14, 12 or 11 it works no problem. I've also tried changing the /'s to -'s and still no-go. I've looked through some…
CycleGeek
  • 473
  • 2
  • 6
  • 14
3
votes
1 answer

Mysql error: 1292 Incorrect datetime value showing a date that doesn't exist

I'm getting an error with this stored procedure: DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `populateTimeTable`(IN table_name VARCHAR(45), IN start_date DATE, IN end_date DATE) BEGIN DECLARE full_date DATE; SET @query_create =…
vjsp90
  • 99
  • 3
  • 10
2
votes
1 answer

MySQL 1292 Truncated incorrect datetime value: '2020-09-11T08:32-50Z'

I need your help. I am trying to transform a text field (containing: 2020-09-11T08:32:50Z) into a date field. I have tried with TIMESTAMP statement and I get the warning: 1292 Truncated incorrect datetime value. I have also tried with STR_TO_DATE…
antonio
  • 23
  • 4
2
votes
1 answer

MySQL 1292 Warning on varchar date value to number conversion

I know why the warning occurs. On a varchar(20) column set to '0000-00-00 00:00:00' format in MySQL which a numeric comparison such as: select * from table where varchar_date_column > 0; is performed... Then I will have warnings that say: Warning |…
Paul Carlton
  • 2,785
  • 2
  • 24
  • 42
1
vote
1 answer

MySQL 1292 Truncated incorrect datetime value: '2020-01-02 07:15:00'

I am trying to insert a Datetime field by concatenating a Date and Time field. Om my local Mysql its working with a warning message , on the server its failing with the same message. Any help on this please Source table (shift details) - CREATE…
Steve
  • 13
  • 1
  • 4
1
vote
1 answer

Incorrect datetime. What i am doing wrong?

i am trying to insert random datetime into my table but when i call the procedure it show me error that is my datatime value incorrect and i do not know why. Please can someone help me and explain? in datumPredvajanja i want to set only date in…
user7928142
1
vote
2 answers

mysql 0000-00-00 update error

I am trying to update a my date field to null instead of 0000-00-00, but I errors. ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'rel_date' at row 1 However I can update the records individually? update table set rel_date =…
user3525290
  • 1,557
  • 2
  • 20
  • 47
1
vote
1 answer

1292 Truncated incorrect INTEGER value

What am I not seeing? I have no idea why I am getting this error. It shouldn't even be asking for an integer. MariaDB [ams]> describe server_current_status; +----------+-------------+------+-----+---------+----------------+ | Field | Type …
Sherman Lilly
  • 11
  • 1
  • 2
1
vote
1 answer

MySQL Error 1292 on insert text

I am trying to insert a combination of 2 fields into one field and every time I do this I get an error about truncating data. The code: insert into sharppatentdb.Inventor (InventorFull) select InventorFirst + " " + InventorLast from…
Johnny B
  • 420
  • 1
  • 5
  • 14
0
votes
2 answers

Mysql Truncated incorrect DOUBLE value in INSERT query

I know there are lots of bugs like this around here but this query seems to be different, as it's an insert query. Here is the schema for the table card_info: CREATE TABLE card_info ( card_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, …
voldomazta
  • 1,300
  • 1
  • 10
  • 19
0
votes
0 answers

How to update timestamp column in MySQL with incorrect timestamp?

I have a database (MySQL 8.0) with four timestamp columns, using the default timestamp settings, i.e. no fraction of seconds. I would like to start using fractions of a second, probably two decimals, so TIMESTAMP(2). The process that generates the…
Nelumbo
  • 893
  • 2
  • 9
  • 18
0
votes
0 answers

Error Code: 1292. Truncated incorrect INTEGER value:

Insert into ocs_trn_tverticalscorecardgrouptitle( application_gid, vertical_gid, grouptitle_gid, grouptitle_name, created_by, created_date ) select 'SEGM2021061648', 'SEGM2021061648', grouptitle_gid,…
Kalaiyarasan P
  • 1
0
votes
1 answer

SQL - MariaDB : SQL Error 1292 Truncated incorrect DOUBLE value

after few search with my buddy G, I found a lot of solution, but no one corresponds to my situation. Quick explanation : I am currently trying to create a "test table" which will receive 4 millions lines per day. That's around 48 lines/seconds. To…
Phaeron
  • 33
  • 6
1
2 3