Rames, Hope this will be useful
http://www.postgresql.org/docs/9.1/static/functions-string.html Jimit Amin On Thu, Jul 9, 2015 at 9:54 PM, Ramesh T <rameshparnandit...@gmail.com> wrote: > Hi, > in oracle regexp_like(entered > date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i') > > for postgres i have regexp_matches ,But i need how to match [:digit:] in > postgres when we pass date..? > any help >