Skip to content

Age

Type Registry

Age

identity.person.age

Person age in years. Numeric string or integer. When inferred as VARCHAR, transforms to SMALLINT.

Domain identity›person
Casts to SMALLINT
Scope Universal

Try it

CLI 
$ finetype infer -i "25"
→ identity.person.age

DuckDB

Detect 
SELECT finetype('25');
-- → 'identity.person.age'
Cast expression 
CAST({col} AS SMALLINT)
Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS SMALLINT) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.person.age';

JSON Schema

finetype schema identity.person.age 
{
  "$id": "https://noon.sh/schemas/identity.person.age",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Person age in years. Numeric string or integer. When inferred as VARCHAR, transforms to SMALLINT.",
  "examples": [
    "25",
    "42",
    "7"
  ],
  "pattern": "^[0-9]{1,3}$",
  "title": "Age",
  "type": "string"
}

Examples

25427

Types in identity