Unexpected behaviour with handling epoch timestamps
#41
by
anirudh-ramesh
- opened
I'm asking sqlcoder-7b-2 a question that does not have any dependency on the schema that I am providing, but I'm still adding a schema to the prompt.
My question is "convert epoch timestamp 1721373324 to timestamp with time zone" and the response is "SELECT '2024-07-19 00:00:00+05:30'::TIMESTAMP WITH TIME ZONE + interval '1721373324 seconds' AS timestamp_with_time_zone;".
I'm running this query on 19th July, and I've specified the current date in the instructions as "- recall that the current date in YYYY-MM-DD format is 2024-07-19".