Getting the time of day out of timestamp/datetime columns in #Pandas #databases is df['date_col'].dt.time. #dates
#SQLite is dynamically typed, but #dates don’t get a storage class of their own; instead you store them as text, real Julian days, or integer Unix epoch timestamps. Separately, columns have a “type affinity” which is drawn from almost the same set as the storage classes. This page explains the type system in detail.
on 02023-12-04#SQLite has date calculation functions that seem like the best #calendar #dates calculation language I’ve seen, except for not supporting time zones: “Compute the number of days since the signing of the US Declaration of Independence: SELECT julianday('now') - julianday('1776-07-04'); Compute the date of the first Tuesday in October for the current year: SELECT date('now','start of year','+9 months','weekday 2');.” That’s pretty great! But for getting a local time out of “2023-04-04 09:30:00-04:00” you’re better off using substr(date, 12, 8).