List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:July 1 2004 9:48am
Subject:Re: time on tenth of secounds
View as plain text  
"Matthias Eireiner" <matthias.eireiner@stripped> 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
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

mysql client connectivity and "orphaned" connectionsJim28 Jun
  • Re: mysql client connectivity and "orphaned" connectionsEric Bergen28 Jun
    • time on tenth of secoundsMatthias Eireiner29 Jun
      • Re: time on tenth of secoundsEgor Egorov1 Jul
  • Re: mysql client connectivity and "orphaned" connectionsEgor Egorov1 Jul