db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikael" <mikael-arons...@telia.com>
Subject Re: How to view TIMESTAMP in yyyy-mm-dd hh:mm:ss format
Date Wed, 03 Sep 2008 08:55:16 GMT
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" <il_zealot@mail.ru>
To: <derby-user@db.apache.org>
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.
> 


Mime
View raw message