Re: mysql timestamp

[Paul DuBois]

At 12:07 -0500 3/12/03, Jonathan Li wrote:
>I currently have a table that contains a timestamp(6) column. I need to
>copy the data in that column to a new table with the column structure as
>timestamp(14), what is the best way to do it (now that the timestamp
>structure is changed)?

That doesn't matter.  TIMESTAMP values are always stored with the full
14 digits, regardless of the display width.

>
>Thanks
>Jonathan
>
>--- ignore below
>query
>sql
>---