On 23 Dec 2002, at 16:11, Akash wrote: > According to MySQL implementation, if I give the default value of the column > during table creation as NULL, it will store the current time in the > timestamp column. I do not want this "current time" to be stored in the > timestamp column. I want it to be NULL. How to do this ?
If you don't like the properties of TIMESTAMP columns, don't use them. Use DATETIME instead, or use an INT and store Unix time in it (thus avoiding some complications of time zones and daylight saving time). -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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
