"Matthias Eireiner" <[EMAIL PROTECTED]> wrote: > problem is, that I want to save the time with the fraction of seconds. > as far as I know MySQL is fine with something like "D HH:MM:SS.fraction", > but doesn't store the fraction. Is there anything that could fix that > problem? > I thought about an extra integer column only for the fraction, but I would > love to use the MySQL built in sub and add functions.
There is no support for fractions in DATETIME type. Feel free to add the fraction manually into another column. Do you really need database's internal functions to support high-resolution time? MySQL is in no case a real-time DBMS. Even inserting a NOW() value into a "high-resolution" DATETIME column will give you an unpredictable result as you never know how much time for server it will take to process the query. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
