#DateForumTypeThreadPost
522 Aug 2016 @ 02:18 PDTDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthThanks Dieter!
422 Aug 2016 @ 10:10 PDTDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthYou, my friend, are awesome! Thanks so much, this worked great! I read more about the ADD_MONTHS and EXTRACT functions to help understand what is happening. Great learning from my first post. I lo...
322 Aug 2016 @ 09:35 PDTDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthCorrection to above on 'however, could I just modify that expression to be "> 2"?'
222 Aug 2016 @ 09:34 PDTDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthThank you for your response, Sachin. This CASE yields the date as the first of that particular month, not the following month which is what I need. I've also noticed that records will store on ...
122 Aug 2016 @ 07:33 PDTDatabaseTopicConvert date > xx/01/xxxx of given month to first of following monthHi, I'm new to the forum and newly learning SQL. I'm hoping for some help on converting dates upon returning the query. The issue I have is that there is a PROCESS_DT field that I'm us...