Thank you for the clarification, Jochem. Actually, any attempt to apply the word "standard" to the many flavors of SQL probably *is* questionable. :)
It may be more appropriate to state that the Month() and Year() functions are available for use in SQL Server's Transact-SQL, Oracle's PL/SQL, and MS Access's Jet SQL. But I'm unfamiliar with SQL:1999. A quick check on google seems to indicate this is an attempt to provide a SQL standard. Care to comment further on that? ~Dina ----- Original Message ----- From: Jochem van Dieten To: CF-Talk Sent: Wednesday, December 11, 2002 10:49 AM Subject: Re: Another Newbie Problem Dina Hess wrote: > Well, Jochem, has already given you some valuable information but since > Month() and Year() are standard SQL functions Maybe they work in some non-standard implementation, but that does not make them standard functions. There is no reference to a Month() or a Year() function in SQL:1999. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
