Re: Localisation problem

2012-10-18 Thread John English
On 17/10/2012 21:40, david myers wrote: John, If you have a look at the java Gregorian calendar class (http://docs.oracle.com/javase/7/docs/api/java/util/GregorianCalendar.html#GregorianCalendar(java.util.TimeZone,%20java.util.Locale) It has a constructor for setting the timezone and locale. I

Re: Localisation problem

2012-10-18 Thread John English
For what it's worth, I've come up with a nasty dirty solution which I'm posting here in case anyone else ever needs it... In my original problem, I had a view which included a column defined like this: TimeFormat(time) AS usr_time, I now have time AS usr_time instead, so that the selected