Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   New version of 'isdate' UDF
 
From:   John Hall

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016