01-date32-intro.py

from datetime import date
import datatable as dt
dt.Frame([dt.Type.date32.min, date(2021, 7, 20), dt.Type.date32.max], stype='date32')

02-date32-create.py

DT = dt.Frame([1, 1000, 100000], stype='date32')
DT

03-date32-create.py

DT = dt.Frame({"Date": ["2021-05-24", "2021-05-26", "2021-05-27"]}, stype='date32')
DT

04-date32-create.py

DT = dt.Frame({"Date": ["2021-05-24", "2021-05-26", "2021-05-27"]})
DT[0] = dt.Type.date32
DT

05-date32-create.py

DT = dt.Frame({"Date": ["05/24/2021", "05/26/2021", "05/27/2021"]}, stype='date32')
DT

06-date32-create.py

DT = dt.Frame({"Date": ["05/24/2021", "05/26/2021", "05/27/2021"]})
DT[:, dt.update(Date = 
                 dt.time.ymd(dt.as_type(dt.str.slice(dt.f.Date, 6, 10), int), 
                             dt.as_type(dt.str.slice(dt.f.Date, 0, 2), int), 
                             dt.as_type(dt.str.slice(dt.f.Date, 3, 5), int)))]
DT

07-time64-intro.py

from datetime import datetime
dt.Frame([dt.Type.time64.min, datetime(2021, 7, 20, 1, 32, 52, 125555), dt.Type.time64.max])

08-time64-create.py

DT = dt.Frame(Time = ["2018-01-31 03:16:57", "2021-06-15 15:44:23.951", "1965-11-25 19:29:00"])
DT[0] = dt.Type.time64
DT

09-time64-create.py

from datatable import f
DT = dt.Frame(Y=[2001, 2003, 2005, 2020, 1960],
              M=[1, 5, 4, 11, 8],
              D=[12, 18, 30, 1, 14],
              h=[7, 14, 22, 23, 12],
              m=[15, 30, 0, 59, 0],
              s=[12, 23, 0, 59, 27],
              ns=[0, 0, 0, 999999000, 123000])
DT[:, dt.update(Time = dt.time.ymdt(f.Y, f.M, f.D, f.h, f.m, f.s, f.ns))]
DT

10-datetime-filter.py

DT[dt.time.year(f.Time) < 2000, :]