MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Stan P. van de Burgt Date:September 3 1999 8:56am
Subject:Re: INSERT NOW() bug?
View as plain text  
Please use stan@stripped to reply
The address  use in the previous email is valid inside the company only

- Stan


At 10:43 3-9-99 +0200, Stan van de Burgt wrote:
> >Description:
>         When inserting NOW() in a DATETIME field is seems to insert
>         the first character of the time wrong.
> >How-To-Repeat:
>
>mysql> create table t1 (d datetime );
>Query OK, 0 rows affected (0.15 sec)
>
>mysql> insert into t1 values (now());
>Query OK, 1 row affected (0.01 sec)
>
>mysql> select * from t1;
>+---------------------+
>| d                   |
>+---------------------+
>| 1999-09-03 50:31:75 |
>+---------------------+
>1 row in set (0.00 sec)
>
>mysql> select now();
>+---------------------+
>| now()               |
>+---------------------+
>| 1999-09-03 10:34:47 |
>+---------------------+
>1 row in set (0.00 sec)
>
>mysql>
>
> >Fix:
>
>
> >Submitter-Id:  SPV
> >Originator:    Stan van de Burgt
> >Organization:
>  Q-go
> >MySQL support: none
> >Synopsis:      inserting NOW() in a DATETIME field leaves stange chars
> >Severity:      non-critical
> >Priority:      low
> >Category:      mysql
> >Class:         sw-bug
> >Release:       mysql-3.22.25 (Source distribution)
> >Server: /usr/local/bin/mysqladmin  Ver 7.11 Distrib 3.22.25, for 
> unknown-linux-gnu on mipsel
>TCX Datakonsult AB, by Monty
>
>Server version          3.22.25
>Protocol version        10
>Connection              Localhost via UNIX socket
>UNIX socket             /tmp/mysql.sock
>Uptime:                 1 day 16 hours 40 min 34 sec
>
>Threads: 1  Questions: 706  Slow queries: 0  Opens: 42  Flush tables: 
>1  Open tables: 13
> >Environment:
>
>System: Linux ideabox.q-go.com 2.0.33 #1 Fri Apr 3 04:21:29 PST 1998 mips 
>unknown
>Architecture: mips
>
>Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc 
>/usr/bin/cc
>GCC: Reading specs from /usr/lib/gcc-lib/mipsel-linux/2.7.2/specs
>gcc version 2.7.2
>Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
>Configure command: ./configure  --with-mit-threads
>Perl: This is perl, version 5.003 with EMBED
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread12176@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.


--
Stan P. van de Burgt    stan@stripped (PGP 0x853296C5)
DMO, P.O. box 1248, 3500 BE, Utrecht, the Netherlands

Thread
INSERT NOW() bug?Stan van de Burgt3 Sep
  • Re: INSERT NOW() bug?Stan P. van de Burgt3 Sep
  • INSERT NOW() bug?Michael Widenius3 Sep
  • Re: INSERT NOW() bug?Harry Brueckner5 Sep
Re: INSERT NOW() bug?Stan P. van de Burgt3 Sep
  • Re: INSERT NOW() bug?Michael Widenius7 Sep