[progress Communities] [progress Openedge Abl] Forum Post: Re: Result Of Select Query For...

  • Thread starter Thread starter Shiva Duriseati
  • Start date Start date
Status
Not open for further replies.
S

Shiva Duriseati

Guest
Hi Greg, The return type of select query will be array of strings irrespective of the data type being used in object column. Please use rbv_api.formatDate(arg1, pattern) function which will format the date according the format specified in the parameter. It will return a valid date , if arg1 is a valid date otherwise it will return null. Example: var date=rbv_api.selectQuery("SELECT dateField FROM SampleObject",1); var formatDate=rbv_api.formatDate(date[0][0], "yyyy-MM-dd HH:mm:ss"); if(formatDate){ rbv_api.println("valid date"); }else { rbv_api.println("invalid date"); } Regards, Shiva

Continue reading...
 
Status
Not open for further replies.
Back
Top