diff options
| -rw-r--r-- | packages/console/app/src/routes/zen/util/handler.ts | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/packages/console/app/src/routes/zen/util/handler.ts b/packages/console/app/src/routes/zen/util/handler.ts index d64922e73..56efe451c 100644 --- a/packages/console/app/src/routes/zen/util/handler.ts +++ b/packages/console/app/src/routes/zen/util/handler.ts @@ -676,7 +676,12 @@ export async function handler( ELSE ${cost} END `, - timeRollingUpdated: sql`now()`, + timeRollingUpdated: sql` + CASE + WHEN UNIX_TIMESTAMP(${SubscriptionTable.timeRollingUpdated}) >= UNIX_TIMESTAMP(now()) - ${rollingWindowSeconds} THEN ${SubscriptionTable.timeRollingUpdated} + ELSE now() + END + `, }) .where( and( |