Archives of the TeradataForum

Message Posted: Mon, 06 Jun 2011 @ 20:02:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

With a contribution from Karl Wridgway, we have new version of the 'isdate' UDF on the website and it can be found at:

www.teradataforum.com/isdate.htm

Based on call parameters (eg- format of date), it tests whether a character string is a valid date. It returns the date if valid, else a NULL is returned. The supported date formats include:

     ddmmyy          yy-mm-dd          ddmmmyyyy (Jan -> Dec)
     ddmmyyyy        yyyy-mm-dd        dd-mmm-yyyy (Jan -> Dec)

     yymmdd          mm-dd-yy          ddmmmmyyyy (January -> December)
     yyyymmdd        mm-dd-yyyy        dd-mmmm-yyyy (January -> December)

     mmddyy          d-m-yy
     mmddyyyy        d-m-yyyy

     dd-mm-yy        yy-m-d
     dd-mm-yyyy      yyyy-m-d

The UDF has three calling signatures:

     isdate(date_char,date_format);

     isdate(date_char,date_format,[separator_char]);

     isdate(date_char,date_format,[separator_char],[century_break]
           ,[fail_mode_flag]);

Please see the website for more information.

The previous version of 'isdate' is still on the website and can be found at:

www.teradataforum.com/isdate_old.htm

	<Prev	Next>		<<First	<Prev	Next>	Last>>