Date alias fields don't have same return type as plain fields

[hanneskuettner]

Describe the Bug

When requesting a date field once normally and once through an alias their return types differ. It seems that alias fields do not receive the same post processing that unaliased date fields receive.

To Reproduce

Especially obvious on SQLite, but also present in other vendors.

• Create a collection with a date_created datetime field
• Request GET /items/<collection>?fields=date,date_created&alias[date]=date_created

Response (in SQLite)

{
  "data": [
    {
      "date": 1718628004468,
      "date_create": "2024-06-17T14:40:04"
    }
  ]
}

Directus Version

v10.12.0

Hosting Strategy

Self-Hosted (Docker Image)

Database

No response