SQL Server with RegExp

Question

Looking for a T-SQL query with regular expression to select records with today's date from sample data as below:

Sample data format:

[DAILY|MASTER|SUPER]-Integer-Date(yyyymmdd)

DAILY-60-20151216
DAILY-61-20151217
SUPER-62-20151218
DAILY-63-20151219
MASTER-64-20151220
DAILY-65-20151221
SUPER-66-20151222
DAILY-67-20151222

Gordon Linoff · Accepted Answer · 2015-12-22 20:48:19Z

2

You don't need a regular expression for this, just the right() function:

where cast(right(data, 8) as date) = cast(getdate() as date)

answered Dec 22, 2015 at 20:48

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

SQL Server with RegExp

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