SQL CURRENT_TIME
Returns the current time of day only — no date component at all.
What & Why
CURRENT_TIME returns the transaction's current time with time-zone information. The worked Queryflo row uses the fixed teaching value 09:30:00+00 beside the real growth.users count.
See How It Works
BUSINESS QUESTION
Using a fixed teaching clock, Growth records a database time beside the user count.
| id | created_at | country | channel | plan | activated_at | churned_at |
|---|---|---|---|---|---|---|
| 101 | 2024-01-15 09:10:00+00 | US | organic | pro | 2024-01-16 14:25:00+00 | NULL |
| 102 | 2024-02-10 11:05:00+00 | CA | paid | free | NULL | 2024-03-20 10:00:00+00 |
| 103 | 2024-03-12 16:35:00+00 | GB | referral | pro | 2024-03-13 08:15:00+00 | NULL |
| 104 | 2024-04-01 13:20:00+00 | US | organic | free | 2024-04-03 12:00:00+00 | NULL |
EXAMPLE QUERY
-- In a live report, replace the teaching value with CURRENT_TIME.
SELECT
TIMETZ '09:30:00+00' AS database_time,
COUNT(*) AS user_count
FROM growth.users;RESULT — exact output from the displayed Queryflo rows
| database_time | user_count |
|---|---|
| 09:30:00+00 | 4 |
The fixed time represents CURRENT_TIME while the count comes from growth.users.
Now You Try
Practice this concept
Return the fixed teaching time 09:30:00+00 beside the growth.users row count.
Available schema
growthPrefix tables with growth.table_name.
database_timeuser_countgrowth.users| Column | Type |
|---|---|
| id | integer |
| created_at | timestamp with time zone |
| country | text |
| channel | text |
| plan | text |
| activated_at | timestamp with time zone |
| churned_at | timestamp with time zone |
| legacy_user_code | text |
query.sql
Sign up free to try it on a real business scenario