def _sqlite_date_trunc(lookup_type, dt): try: dt = typecasts.typecast_timestamp(dt) except (ValueError, TypeError): return None if lookup_type == 'year': return "%i-01-01 00:00:00" % dt.year elif lookup_type == 'month': return "%i-%02i-01 00:00:00" % (dt.year, dt.month) elif lookup_type == 'day': return "%i-%02i-%02i 00:00:00" % (dt.year, dt.month, dt.day)
def _sqlite_extract(lookup_type, dt): try: dt = typecasts.typecast_timestamp(dt) except (ValueError, TypeError): return None return str(getattr(dt, lookup_type))