MVSFORUMS.com A Community of and for MVS Professionals    FAQ   Search   Quick Manuals   Register   Profile   Log in to check your private messages   Log in  Search found 1 match MVSFORUMS.com Forum Index Author Message   Topic: SQL Challenge - II imone Replies: 8 Views: 15986 Forum: Mainframe Challenge   Posted: Wed Sep 21, 2005 4:46 pm   Subject: SQL Challenge - II This can be used to get Third saturday of any month. SELECT (DATE('2005-02-28') - DAY('2005-02-28') DAY + 1 DAY) + ((7 - DAYOFWEEK(DATE('2005-02-28 ...   Page 1 of 1 All times are GMT - 5 Hours Jump to: Select a forum Announcements----------------MVSFORUMS - Announcements Help Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & A General----------------Tools and DownloadsIT News Technical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF  MVSFORUMS Powered by phpBB © 2001, 2005 phpBB Group