Formati di data e ora nei modelli di filtro per i database

Ultimo aggiornamento : Sep 17, 2025 |
Note:
Nei formati che contengono data e ora, POM interpreta HH come un formato a 24 ore. Nei formati che hanno solo l'ora citata in HH:mm, POM interpreta HH come formato a 12 ore.
La tabella seguente fornisce i formati di data e ora supportati nei modelli di filtro per diversi database:
Prolog information
Database
Formati data supportati
Formati ora supportati
Postgres
  • MM
  • GG
  • AA
  • MM, GG, AA
  • GGMM AAAA
  • MMGGAA
  • MMGGAAAA
  • MMAA
  • MMAAAA
  • HH24
  • MI
  • SS
  • HH24MI
  • MISS
  • HH24SS
  • HH24MISS
  • HH:mm:ss
  • gg-MM-aa HH:mm:ss
  • MM-gg-aaaa HH:mm:ss
  • aaaa-gg-MM HH:mm:ss
  • aaaa-MM-gg HH:mm:ss
  • gg.MM.aaaa HH:mm:ss
  • MM.gg.aaaa HH:mm:ss
  • aaaa.gg.MM HH:mm:ss
  • aaaa.MM.gg HH:mm:ss
  • gg/MM/aaaa HH:mm:ss
  • gg/MM/aaaa HH:mm:ss
  • aaaa/gg/MM HH:mm:ss
  • aaaa/MM/gg HH:mm:ss
Oracle
  • MM
  • GG
  • AA
  • MMGG
  • AAAA
  • MMGGAA
  • MMGGAAAA
  • MMAA
  • MMAAAA
  • MM, GG, AA
  • GGMM, AAAA
  • HH24
  • MI
  • SS
  • HH24MI
  • MISS
  • HH24SS
  • HH24MISS
  • HH:mm:ss
  • gg-MM-aa HH:mm:ss
  • MM-gg-aaaa HH:mm:ss
  • aaaa-gg-MM HH:mm:ss
  • aaaa-MM-gg HH:mm:ss
  • gg.MM.aaaa HH:mm:ss
  • MM.gg.aaaa HH:mm:ss
  • aaaa.gg.MM HH:mm:ss
  • aaaa.MM.gg HH:mm:ss
  • gg/MM/aaaa HH:mm:ss
  • gg/MM/aaaa HH:mm:ss
  • aaaa/gg/MM HH:mm:ss
  • aaaa/MM/gg HH:mm:ss
MSSQL
  • AAAA
  • GG, MM, AAAA
  • MM
  • GG
  • HH24
  • MI
  • SS
  • HH24MI
  • MISS
  • HH24SS
  • HH24MISS
  • HH:mm:ss
  • gg-MM-aa HH:mm:ss
  • MM-gg-aaaa HH:mm:ss
  • aaaa-gg-MM HH:mm:ss
  • aaaa-MM-gg HH:mm:ss
  • gg.MM.aaaa HH:mm:ss
  • MM.gg.aaaa HH:mm:ss
  • aaaa.gg.MM HH:mm:ss
  • aaaa.MM.gg HH:mm:ss
  • gg/MM/aaaa HH:mm:ss
  • gg/MM/aaaa HH:mm:ss
  • aaaa/gg/MM HH:mm:ss
  • aaaa/MM/gg HH:mm:ss