# Pastebin Y5lG7iWt ➜ Red git:(master) ✗ raku -I. -MRed -e ' model Bla { has $.id is serial; has DateTime $.a is column } red-defaults "SQLite"; Bla.^create-table; my $*RED-DEBUG = True; .say for Bla.^all.map: { .a.year, .a.month, .a.day } ' SQL : SELECT STRFTIME('%Y', DATE(bla.a)) as "data_1", STRFTIME('%m', DATE(bla.a)) as "data_2", STRFTIME('%d', DATE(bla.a)) as "data_3" FROM bla BIND: []