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

Service Event: End Date, DateTime YYYY-MM-DD

Definition

The date a service event was completed.

Components

Data Element (this item)
Service Event: End Date, DateTime 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 0
Output in Derivations 0
Inclusion in Data Set Specifications 1
Inclusion in Data Distributions 14
As a numerator in an Indicator 1
As a denominator in an Indicator 1
As a disaggregation in an Indicator 0