How to convert varchar yyyy-mm to date

Question

I have a column of data in the format of yyyy-mm that is VARCHAR(7). Using CONVERT doesn't work and I'm guessing it's because it needs a day in the string (yyyy-mm-dd), but I don't know how to add that to the string. I started with this code:

SELECT * FROM TABLE_X WHERE MONTH BETWEEN ('2022-06','2023-06')

Stu, if I understand you correctly, I should have mentioned that this is in Snowflake. — NOLA_Max
– NOLA_Max, Commented Jul 26, 2023 at 21:59

Felipe Hoffa · Accepted Answer · 2023-07-26 22:15:39Z

1

How about:

SELECT * 
FROM TABLE_X 
WHERE MONTH BETWEEN '2022-06' AND '2023-06'

The comparisons between string will work, as the question states that "column of data in the format of yyyy-mm that is VARCHAR".

answered Jul 26, 2023 at 22:15

Felipe Hoffa

59.8k23 gold badges185 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert varchar yyyy-mm to date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related