Hi All, On Jun 8, 2:06 pm, "Scott Thornton" <scott.thorn...@hnehealth.nsw.gov.au> wrote: > Hi, > > pretty sure that collation refers to sort order. > > Language refers to date format however, but I could not find a server wide > setting to change it. > > SELECT @@LANGUAGE AS 'Language Name' returns us_english in my SQL 2005 > server. If the language was British it would default to dmy > > select * from master.dbo.syslanguages to check out the dateformats available. > > I gave up on CF and SQL working well with European\Aussie dates long ago. > > I like using SET DATEFORMAT DMY in all of my procedures, and within CF > DateFormat( x, "dd-MMM-yyyy") but I agree that we should not have to. >
Ahhh thats the one - thanks Scott! Looks loie we do the same thing... manually ensure that the dateformat is manually handled prior to insertion into the database - regardless of format chosen. Sorry for the misleading LOCALE setting Mike! Gavin. > >>> Mike Kear <afpwebwo...@gmail.com> 08/06/2010 1:51 pm >>> > > @mgk: I'm doing the updates using ColdFusion. The only property I can find > that's remotely associated with language or nationality or locale is the > collation = SQL_Latin1_General_CP1_CI_AS > > Can this be set to something else? Does it set the default date format > property? > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworkshttp://afpwebworks.com > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > > On Tue, Jun 8, 2010 at 1:46 PM, m...@ampersand.net.au > <m...@ampersand.net.au>wrote: > > > I've been doing some more reading - slow day today - apparently the date > > format used can also depend on the user logged in to the database - if you > > get properties of the login you are using to do the updates (in management > > studio) is it English or British English? > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaus...@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group > athttp://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.