what is the format of the string returned when rs.getString("timestamp_with_time_zone_field")
0 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Alp_Keskin
Posted On:   Thursday, March 31, 2005 11:03 PM

I want to retrieve TIMESTAMP WITH TIME ZONE field from Oracle using JDBC.. I have to retrieve it as String so that I can have the Time Zone information, otherwise I lose tz.. When I retireve this field I get this string: "2004-8-8 9.0.0.123457000 US/Eastern" Where is the format of this string defined? Is it defined in the database or jdbc? I would appreciate any info about the format of the date/time string when I retrieve the date as String using JDBC.. Thanks..    More>>

I want to retrieve TIMESTAMP WITH TIME ZONE field from Oracle using JDBC..



I have to retrieve it as String so that I can have the Time Zone information, otherwise I lose tz..



When I retireve this field I get this string: "2004-8-8 9.0.0.123457000 US/Eastern"


Where is the format of this string defined? Is it defined in the database or jdbc?



I would appreciate any info about the format of the date/time string when I retrieve the date as String using JDBC..



Thanks..

   <<Less
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact