@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-818 a edu:Knobit ;
    rdfs:label "Point in time without a zone, business date with a clock (generated DDL)"@en ;
    dcterms:identifier "K-818" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 05-ddl, row 18; ISO 8601; ISO 9075"@en ;
    skos:definition "Two mirror-image defects. An event timestamp with no offset is ambiguous twice a year and incomparable across a bank that books in more than one zone. A business date — value date, booking date, maturity date, due date — stored as a timestamp invites a time component nobody means and makes date equality quietly fail."@en ;
    skos:prefLabel "Point in time without a zone, business date with a clock (generated DDL)"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `created_at TIMESTAMP` with no zone on `dim_account`, written by jobs in two regions. And `payment_value_date` as a `TIMESTAMP`, so `= DATE '2026-03-31'` matches none of the rows loaded at 23:30 Acceptable: `TIMESTAMP WITH TIME ZONE` for event times, or UTC with the convention stated in the column `comment` and nowhere else; `DATE` for `payment_value_date`, `loan_maturity_date` and `valid_from_date`/`valid_to_date`, as the sample model has them"@en ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "A finding that names the defective generated DDL element and the defect"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "generated DDL"@en ;
    schema:creativeWorkStatus "superseded" ;
    schema:isPartOf register:data-modelling ;
    schema:supersededBy knobit:K-827,
        knobit:K-828 .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-827 rdfs:label "Recognises a time zone dropped from a timestamp"@en,
        "Recognises an event timestamp stored without a time zone"@en .

knobit:K-828 rdfs:label "Recognises a business date stored with a time of day"@en .