I am performing this script:


Choose EXTRACT(HOUR FROM TIMEDIFF('2009-12-12 13:13:13', NOW()))

And i am getting: -838. Is the farthest MySQL can move up to when removing?

You are able to overcome this limit having a workaround

   select
   datediff(now(),'2009-12-12 13:13:13') * 24
    + extract(hour from now())
    - extract(hour from '2009-12-12 13:13:13') as hour_diff

This is actually a limitation from the [cde] type.

Automatically, values that lie outdoors time range but they are otherwise legal are clipped towards the nearest endpoint from the range. For instance, '-850:00:00' and '850:00:00' are transformed into '-838:59:59' and '838:59:59'. Illegal TIME values are transformed into '00:00:00'. Observe that because '00:00:00' is itself a legitimate TIME value, there's not a way to inform, from the worth of '00:00:00' saved inside a table, if the original value was specified as '00:00:00' or whether or not this was illegal.