mysql concatenating extract results with string

Question

Current Code:

WHERE EXTRACT(YEAR_MONTH FROM timestamp_field) = EXTRACT(YEAR_MONTH FROM now())")

Instead of EXTRACT(YEAR_MONTH FROM now()), I want EXTRACT(YEAR FROM now()), but I want to hard code the month in. How do I go about concatenating the extract results with the MM month, for example 09.

I tried a few options below, with no luck.

(EXTRACT(YEAR FROM now())09)

CONCAT(EXTRACT(YEAR FROM now()), 09) 

'EXTRACT(YEAR FROM now())' + '09'

Bill Karwin · Accepted Answer · 2009-09-14 18:21:29Z

2

You almost had it:

SELECT CONCAT(EXTRACT(YEAR FROM now()), '09');

The "+" operator is not for string concatenation, unless you use Microsoft SQL Server.

In MySQL, use CONCAT() or if you set SQL mode to ANSI or PIPES_AS_CONCAT you can use the standard "||" operator:

SET SQL_MODE := 'ANSI';
SELECT EXTRACT(YEAR FROM now()) || '09';

answered Sep 14, 2009 at 18:21

Bill Karwin

567k87 gold badges711 silver badges872 bronze badges

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

1 Comment

payling Over a year ago

Doh... indeed.. Sooo close. Thanks Bill

Collectives™ on Stack Overflow

mysql concatenating extract results with string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related