Count logo iconCount square logo purple
Product
Pricing
Services
Customers
Gallery
Resources
Sign inGet started
Make BI Stand for Business Improvement
Identify
Make your business visible
Explore
Find better answers quicker
Monitor
Stay closer to change
Decide
Reduce time to decision
Features
Whiteboard
Alerts
Cells
Reports
Visuals
Low-code
Count Metrics
All features
Use cases
Metric trees
Reporting
Data exploration
Data modelling
No items found.
Latest
Resources
Blog
Webinars
Podcast
Case studies
Example canvases
Data leader community
Support
Documentation
Knowledge base
SQL tutorials
Business Improvement
Identify
Explore
Decide
Monitor
Product
Whiteboard
Cells
Visuals
Alerts
Report mode
Low-code
Count Metrics
Use cases
Metric trees
Reports + storytelling
Data modelling
Data exploration
Pricing
Professional Services
Customers
Resources
Blog
Podcast
Community
Events
Docs
Sign in
SQL Tutorials
Understanding FROM
Understanding JOIN
Understanding WHERE
Using dates in SQL
Using strings in SQL
SQL Functions
Case
Count
BigQuery Tutorials
Arrays explained
Data types
Dates and Times
String Functions Explained
Window Functions Explained
BigQuery Functions
ARRAY_AGG
CASE
CAST
COALESCE
CONCAT
COUNT [DISTINCT]
CURRENT_DATE
CURRENT_DATETIME
CURRENT_TIMESTAMP
DATE_DIFF
DATE_TRUNC
DATETIME_DIFF
DATETIME_TRUNC
EXTRACT
IF
MEDIAN
SUBSTR
TIME_DIFF
TIME_TRUNC
TIMESTAMP_DIFF
TIMESTAMP_TRUNC
UNNEST
Snowflake Tutorials
Histograms
Linear Regression
Moving Averages
Pivot Tables
Running Totals
Summary Statistics
Window Functions
SQL Server Tutorials
Data Types
Dates and times
SQL Resources
SQL
CURRENT_DATE

CURRENT_DATE

Definition

The BigQuery CURRENT_DATE function returns the date at the time the query is evaluated. By default the date will be in UTC timezone but a specific timezone can be selected.

Syntax

CURRENT_DATE([time_zone])
SELECT
  CURRENT_DATE() AS date_utc,
  CURRENT_DATE('Australia/Sydney') AS date_sydney,
  CURRENT_DATE('+08:00') AS date_plus_8
date_utcdate_sydneydate_plus_8
2021-02-122021-02-122021-02-12

Practical Info

  • The returned data type is a DATE.
  • The full list of supported timezone names can be found here.
  • If the time_zone argument is NULL the function returns NULL.

    • Related Pages

  • CURRENT_DATETIME
  • CURRENT_TIMESTAMP
    • Subscribe to newsletter

    Subscribe to receive the latest blog posts to your inbox every week.

    By subscribing you agree to our Privacy Policy.
    Thank you! Your submission has been received!
    Oops! Something went wrong while submitting the form.

    Start solving your organization's biggest problems with Count today.

    Stay up to date with all things count, data and problem solving.

    Get startedBook a demo