Re: Internationalization for mckoi

Hi,

When specifying dates in an SQL query using the DATE literal, the format 
is locale independent.  The DATE literal uses the SQL standard format of 
'year-month-day'.  When retrieving information from a query, the 
database client may format the java.sql.Date object in a locale specific 
format.  But when entering a date in a query, the format will not change 
regardless of locale.

For example, 28th January 2005 would be represented by DATE '2005-01-28' 
in an SQL query.

Toby.

Justin Cobb wrote:
> Toby,
> 
> Do I need to specify Locale when I create and start the database up? Or
> does Mckoi do a locale lookup on it's own? I am running into a problem
> when running on a German Locale when I send the query to the database
> for a Date range. I assume that if I set the Locale in my code to format
> the date accordingly that mckoi will be able to handle it?
> 
> Thanks, Justin.



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]