>Daniel Kessler wrote: >#3 - Apparently there are no Month() and Year() functions, which is >fine, neither does postgres... so I'll have to figure out how to create >those functions too. I've done them for postgres so it shouldn't be all >that difficult.
Out of curiosity, why rely on the database for these functions when Coldfusion has perfectly good equivilents? As for Oracle, there aren't functions with that specific name, however you can use TO_CHAR to accomplish the same thing - i.e. TO_CHAR(<date>, 'MONTH') gives you the full name of the month. http://www-db.stanford.edu/~ullman/fcdb/oracle/or-time.html is a good reference. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
