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?
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.
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With