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".

Sign up or log in to comment