MySQL Forums
Forum List  »  Docs

Advanced Search
New Topic

TIMESTAMP column in windows 2000
Posted by: Girish Agarwal
Date: November 16, 2005 02:19PM

Hi All,
I am in process of migrating the mysql database ( version 4.1 ) from a linux Machine to Windows.
After Migration I see the TIMESTAMP(8) column in Linux became TIMESTAMP column in windows 2000 as as result it displays complete date and time instead of DATE. Is that behaviour by design or am I missing something.
After Migration , I am using the command ALTER TABLE good_table MODIFY doc TIMESTAMP(8) NOT NULL; and trying to convert TIMESTAMP to TIMESTAMP(8) but in vain. Please advise.

Thanks,
Girish



Edited 1 time(s). Last edit at 11/16/2005 02:23PM by Girish Agarwal.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
TIMESTAMP column in windows 2000
4397
Girish Agarwal
November 16, 2005 02:19PM
Re: TIMESTAMP column in windows 2000
2296
Mike Hillyer
December 01, 2005 12:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.