Currently one has to get a date conversion using soemthing like this:
(getyear(CreationDate)*10000 + getmonth(CreationDate)*100 + getday(CreationDate) in order to convert the date to number and then use it to compare dates.
I would like to propose the convertToNum(date) and converttoDate(number) functionalities in SQL. These would be very useful to me and I am sure for many others as well.
Please sign in to leave a comment.