Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
Metadata.NSW (beta)

Definition

A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day.

Components

Data Element (this item)

Representation

This representation is based on the value domain for this data element, more information is available at " DateTime YYYY-MM-DD[Thh:mm:ss] ".
Description

A BigQuery datetime value element that is automatically combined with a time of day of midnight based on a 24-hour clock, using local server time - time zone information using UTC offsets is not stored. If no time is specified, the time portion defaults to 00:00:00. If no day or month is specified, the values default to 01.

DateTime YYYY-MM-DD(T00:00:00) Notation Elements, Meanings and Obligations

Element Meaning Obligation
YYYY A four digit year Required
MM A zero-padded month between 01 and 12 Optional
DD A zero-padded day between 01 and 31 Optional
hh A zero-padded hour between 00 and 23 Automatic
mm A zero-padded minute between 00 and 59 Automatic
ss A zero-padded second between 00 and 59 Automatic
Data Type DATETIME
Format YYYY-MM-DD(T00:00:00)
Maximum character length 20

Related content

Relation Count
Input in Derivations 3
Output in Derivations 0
Inclusion in Data Set Specifications 0
Inclusion in Data Distributions 89
As a numerator in an Indicator 32
As a denominator in an Indicator 5
As a disaggregation in an Indicator 0