Saving a UNIX timestamp in MySQL as type DOUBLE?

Question

My function call takes some input, and throws it into a database. Usually, it's integers, but today, I need it to throw in a unix timestamp.

This overflew the FLOAT type, but works with type DOUBLE.

Is there anything I should be worried about by saving that 10-digit integer in type DOUBLE?

I did found a strange error, posted here: stackoverflow.com/questions/9503646/… — Serbu Florin-Adrian
– Serbu Florin-Adrian, Commented Feb 29, 2012 at 17:18

Marco Mariani · Accepted Answer · 2010-11-16 16:14:54Z

2

The total precision of a DOUBLE PRECISION value is approximately 16 decimal digits, so you should not worry, even if you store milliseconds or microseconds.

answered Nov 16, 2010 at 16:14

Marco Mariani

13.8k7 gold badges42 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Julian H. Lam Over a year ago

Cheersh! So float, then, would be 8 digits, I assume?

Marco Mariani Over a year ago

for a 32 bit floating point, 24 bits of significand precision, log10(2^24) ≈ 7.225 decimal digits

Collectives™ on Stack Overflow

Saving a UNIX timestamp in MySQL as type DOUBLE?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related