Re: how to test a string for a valid date in sql

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 13 Dec 2009 12:02:50 +0100
Message-ID: <4b24c9da$0$2864$ba620e4c_at_news.skynet.be>



Shakespeare wrote:
>
> How about checking if to_char(to_date(varcharstring)) = varcharstring?
> (Did not test it, just an idea)
>
> Shakespeare

Better stick to plays and sonnets, S. Received on Sun Dec 13 2009 - 05:02:50 CST

Original text of this message