Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

what is a fractional second?

Tags:

date

time

double

I am trying to understand what a fractional second is. I found a fractional second,here:

double uhd::time_spec_t::get_frac_secs  (   void        )    const
     Get the fractional part of the time in seconds.

Returns:
     the fractional seconds

What exactly is a fractional second represented as a double? Can someone give me an example value and how that translates in to seconds?

like image 958
gnychis Avatar asked Jan 20 '12 06:01

gnychis


People also ask

How many fractions are in a second?

1 hr has 3600 seconds. So 1 second/1 hour = 1 second/3600 seconds = 1/3600. So 1second is 1/3600 fraction of an hour.

What does a fraction of time mean?

Used by itself, 'fraction of times' generally means 'hardly ever' or very few times at all. For example, 'He only went to the doctor a fraction of times' means he only went to the doctor a few times or hardly at all.

How do I convert seconds to fractions in SQL?

To define a column that includes a fractional seconds part, use the syntax type_name ( fsp ) , where type_name is TIME , DATETIME , or TIMESTAMP , and fsp is the fractional seconds precision. For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6)); The fsp value, if given, must be in the range 0 to 6.


1 Answers

Fractional second is the part of the time that is not an integer. So if you have a time like 12345678.9 the fractional second is 0.9

like image 171
Basile Starynkevitch Avatar answered Sep 17 '22 19:09

Basile Starynkevitch