PostgreSQL Wildcard number

Question

I have two attributes in table (char and date) like a 90061455555 and 1990-06-14. I must create references where third and fourth number in first attribute (90061455555) are the same as month in date attribute (1990-06-14). and similar: 90061455555 1990-06-14 90061455555 and 1990-06-14

How I can do this?

Gordon Linoff · Accepted Answer · 2017-12-12 19:27:47Z

1

I would simply do:

where substr(strcol, 3, 2) = to_char(datecol, 'MM')

answered Dec 12, 2017 at 19:27

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL Wildcard number

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