Validate Date at MySQL

Question

How do you validate a date in MySQL ? In SQL Server, we have "ISDATE()" to validate whether the expression is a valid date. What function do we use in MySQL ?

Answer 1

Simply use date(your_date_here) and that will check if a date is valid.

EDIT:

If you really wanna have a isDate returning true or false, you can use this:

CREATE FUNCTION IsDate (sIn varchar(1024)) RETURNS INT 
BEGIN 
declare tp int; 

if (select length(date(sIn)) is null )then 
set tp = 0; 
else 
set tp = 1; 
end if; 
RETURN tp; 
END 

cheers

Answer 2

Try a solution like this one I used with Oracle to Sql Server move in SSIS. http://stackoverflow.com/questions/2231028/dealing-with-timestamp-datetime-when-copying-data-from-oracle-to-sql-server-using/2231164#2231164
From your description, Oracle and MySql appear to handle dates similarly.