List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 12 2003 6:08pm
Subject:Re: mysql timestamp
View as plain text  
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
>---

Thread
mysql timestampJonathan Li12 Mar
  • Re: mysql timestampPaul DuBois12 Mar