MacOS Sonoma 14.3 - Query problem with date

[louiskabo]

While attempting to run this script on a 2023 MacBook Pro with MacOS Sonoma v14.3, I am encountering the following error:

    (datetime.date(2016, 10, 5), datetime.date(2024, 1, 22))
TypeError: descriptor 'date' for 'datetime.datetime' objects doesn't apply to a 'int' object

I believe the problem line is:

## High Sierra and above
messages = pd.read_sql_query('''select *, datetime(date/1000000000 + strftime("%s", "2001-01-01") ,"unixepoch","localtime")  as date_utc from message''', conn)

I will say, it still ran, good job!

[yortos]

Thanks for surfacing that! This smells like a format issue.
in the line below, indeed the 'date_utc' column is an int.

## High Sierra and above
messages = pd.read_sql_query('''select *, datetime(date/1000000000 + strftime("%s", "2001-01-01") ,"unixepoch","localtime")  as date_utc from message''', conn)

but I the column 'date_utc' is not even used as the date column.
In the lines below I convert the date_utc (which is an int) to a timestamp object, and then immediately after I take that timestamp and extract just the date in a column called ... 'date'. This is the column used for all date analysis.

# these fields are only for ease of datetime analysis (e.g., number of messages per month or year)
messages['message_date'] = messages['date']
messages['timestamp'] = messages['date_utc'].apply(lambda x: pd.Timestamp(x))
messages['date'] = messages['timestamp'].apply(lambda x: x.date())

Did you run anything else besides all the lines in order? Trying to see if I can help you debug.