New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migrate script batch time interval smaller than expected #38

Open

mtheck opened this issue Aug 25, 2024 · 0 comments

mtheck commented Aug 25, 2024 •

edited

Loading

timescaledb-extras/migrate.sql

Lines 119 to 120 in 52443a4

    
           -- convert the passed in interval to microseconds 
        
           SELECT EXTRACT(epoch from batch_time)*100000 into interval_internal;

The conversion of the batch time interval as epoch to microseconds uses a multiplication by 1e5 instead of 1e6.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment