List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:June 2 1999 4:56pm
Subject:UDF: valid_date
View as plain text  
Uploaded to:
 http://empyrean.lib.ndsu.nodak.edu/~nem/mysql/udf/

Requires one argument (date, date time, int, or string of ints)
  Minimum input is YYMMDD
Optional argument FORMAT_RETURN

Return value:
  If all the elements of the date and time are in the proper range for
  the given year and month then the input is returned. Otherwise NULL
  is returned.

  Additionally if the argument is numeric or a numeric string and
  FORMAT_RETURN is the 2nd argument, then the 1st argument is returned
  with standard MySQL formatting.

  jim...

PS. The recent request for max_month_days() could easily be added if you
folks still want it.
Thread
UDF: valid_dateJim Faucette2 Jun
  • Re: UDF: valid_dateJim Faucette3 Jun