What do you mean with "Derby server to return timestamp columns in ISO
format." ?
A timestamp is a long value, it is not formatted in any way, formatting is
done by the client application, not Derby, for example, the toString()
method
in Timestamp formats the time in ISO 8601 format, but many applications
format
dates and times using the current Locale.
When you say "But my application selects data from this table in
'08/06/08 11:36 AM MSD' format." do you mean that your application
ask SQL queries using that format ?
If that is the case then you will have to look into your application and
check
if it is possible to change that format in any way, maybe changing the
locale.
----- Original Message -----
From: "ilyak" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, September 03, 2008 10:28 AM
Subject: How to view TIMESTAMP in yyyy-mm-dd hh:mm:ss format
Hello all, please help me!
My application connects to the Derby DB.
jdbc:derby://***.***.***.***:1527/MY_DB;
And uses org.apache.derby.jdbc.ClientDriver
I use a table with TIMESTAMP fields
and insert values in it using ij in '2008-08-16 01:24:31' (ISO) format.
But my application selects data from this table in '08/06/08 11:36 AM MSD'
format.
Please tell me how to say Derby server to return timestamp columns in ISO
format.
Because haven't possibility to change source code of this application.:(
And is it possible to disable such localization?
Thanks,
Ilya
--
View this message in context:
http://www.nabble.com/How-to-view-TIMESTAMP-in-yyyy-mm-dd-hh%3Amm%3Ass-format-tp19285007p19285007.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
