I have created a test table for different data types as follows: CREATE TABLE AllDataTypes ( id INTEGER,
col_bit BIT, col_boolean BOOL, col_tinyint TINYINT, col_smallint SMALLINT, col_int INT, col_integer INTEGER, col_bigint BIGINT, col_float FLOAT, col_double DOUBLE, col_char CHAR, col_char1 CHAR(1), col_char255 CHAR(255), col_varchar1 VARCHAR(1), col_varchar255 VARCHAR(255), col_decimal DECIMAL, col_decimal2 DECIMAL(10,2), col_numeric NUMERIC, col_numeric2 NUMERIC(10,2), col_date DATE, col_time TIME, col_timestamp TIMESTAMP, col_datetime DATETIME, col_binary MEDIUMBLOB, col_varbinary MEDIUMBLOB, col_longvarbinary MEDIUMBLOB, col_blob MEDIUMBLOB, col_clob TEXT, col_longvarchar MEDIUMTEXT ); When I execute a query as follows: INSERT INTO AllDataTypes (id, col_date) VALUES (1, '2002-11-23'); The table contains the right values for 'id' and 'col_date' as well as all other columns with 'NULL', except a column, 'col_timestamp'. The column, 'col_timestamp' contains a value, '20021124000012'. So I tested with more queries such as: INSERT INTO AllDataTypes (id) VALUES (2); INSERT INTO AllDataTypes (id, col_date, col_time) VALUES (1, '2002-11-23', '23:50:12'); But the results was same that the column, 'col_timestamp' is containing the values for above two entries. Isn't it suppose to be 'NULL'? Thanks Pae --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
