MySQL Forums
Forum List  »  Informix

Re: Converting Informix datetime data types
Posted by: Josh Chamas
Date: September 26, 2004 09:37AM

Hi Partha,

MySQL does not currently have date and time types with this level of sub-second precision. If you really need to store this precision, you might break out a second FLOAT column and use that precision when necessary for the non-date portion of your data. You might suggest under what circumstances you need this kind or precision for other work arounds, for example if this is merely for queueing accuracy based on time, then you might use a float and store a unix/windows timestamp directly in the column.

Regards,

Josh


Options: ReplyQuote


Subject
Views
Written By
Posted
11752
September 23, 2004 10:49AM
Re: Converting Informix datetime data types
8406
September 26, 2004 09:37AM


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.