[Agent uses the wrong data type when pulling data from Bigquery]

·Jul 01, 2025 02:48 PM·

[Agent uses the wrong data type when pulling data from Bigquery] created_at timestamp: 1.738171111124E9 whereas in the Bigquery table, I have some timestamp. Then the agent interprets wrongly the data (in my case, it transformed the date to the future)

4 comments

· Sorted by Oldest

Hugo Hahn
·
·
the agent
Loading attachments
Hugo Hahn
·
·
In bigquery: 2025-06-26 20:57:56.502000 UTC
In agent: 1.750971476502E9 => "October 27, 2025"
Remi
·
·
Thanks Hugo Hahn for your question! Have you tried to iterate on the instructions to "train" the agent to properly deal with dates? Sometimes, adding things like "Always convert the date in this way: X" can help. I'll flag this to the eng team just in case!
Hugo Hahn
·
·
Nope I did not, will do 🆗

Hugo Hahn
·
·
the agent
Loading attachments
Hugo Hahn
·
·
In bigquery: 2025-06-26 20:57:56.502000 UTC
In agent: 1.750971476502E9 => "October 27, 2025"
Remi
·
·
Thanks Hugo Hahn for your question! Have you tried to iterate on the instructions to "train" the agent to properly deal with dates? Sometimes, adding things like "Always convert the date in this way: X" can help. I'll flag this to the eng team just in case!
Hugo Hahn
·
·
Nope I did not, will do 🆗