search

Canner / WrenAI

🚀 Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! 🙌
https://getwren.ai/oss
GNU Affero General Public License v3.0
1.73k stars 155 forks source link

Timestamp showing unformatted value when previewing data #434

Open wwwy3y3 opened 3 months ago

wwwy3y3 commented 3 months ago

Describe the bug Timestamp showing unformatted value when previewing data

To Reproduce Steps to reproduce the behavior:

  1. Ask basic "show me orders" questions that will query date/timestamp column
  2. See values in date/timestamp column

Expected behavior Values should be formatted. Maybe we should give LLM instructions to format date/timestamp by default ?

Screenshots Screenshot 2024-06-20 at 5 51 46 PM

Desktop (please complete the following information):

WrenAI Information

ovachiever commented 2 months ago

Seeing the same issue. I can ask it to convert from epoch time and it typically does, but users won't know to do this.