List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:June 2 1999 8:31pm
Subject:Re: UDF: valid_date
View as plain text  
Other optional arguments have been added. MAX_DAYS, USE_LAST_DAY, and
USE_LAST_TIME. These options should handle most of the recent requests
for added date functionality.

> 
> 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.
>
Thread
UDF: valid_dateJim Faucette2 Jun
  • Re: UDF: valid_dateJim Faucette3 Jun