in reply to Re: datetime insertion problem
in thread datetime insertion problem

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re^3: datetime insertion problem
by fishbot_v2 (Chaplain) on May 27, 2006 at 21:32 UTC

    The DATETIME type doesn't save a string. It stores it internally as a numeric type, which it autocasts for you. If you want to save it with a particular formatting, you need to use a different type. If I recall, DATETIME fields are a fixed 8-bytes, at least in mySQL5, you are trying to save something much longer.