Hello,
I would like to be able to check whether some date is a valid date by
asking postgresql? Is this possible? The idea is that when an invalid
date is entered into a postgresql table an error is output. Thus to
check the validity of a date from JDBC in a rather lazy way one could
create a table called checkdate with a single column of type date and
insert into that column. If the database generates an error than an
SQLException is output and the user knows that the date is incorrect
and thus needs to prompt for a date again. Now I want to do the
above without having to create any tables. Is this possible?
Thanks,
Neil