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

Record: DateTime Stamp, YYYY-MM-DD

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)
Record: DateTime Stamp, YYYY-MM-DD

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 90
As a numerator in an Indicator 32
As a denominator in an Indicator 5
As a disaggregation in an Indicator 0