473,385 Members | 1,983 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Change default TimeZone in DB2 [JDBC]

Hi,

is it possible to change default time zone in setting timestamp object ? ps.setTimestamp(int index, TimeStamp ts) set TS in database with DB time zone. I know that in Oracle exists method on connection setDefaultTimeZone(TimeZone) that change this zone in setting. Is it something like this in DB2, too?

thx for any commnets
Jun 30 '08 #1
1 8807
Please take a look at this link.Hope it helps!

link

With Regards,
Siva
Jul 1 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: cnliou | last post by:
Hi! If I correctly understand v7.4 manual, value, say, '2003-11-26 12:00' in TIMESTAMP WITHOUT TIMEZONE column should output '2003-11-26 19:00' for "+08:00" timezone. The following test...
1
by: yongsing | last post by:
I have a Windows 2000 Server machine that runs DB2 UDB v7 fixpak 11. I also have a Java program that uses JDBC to insert data into the database. Sometimes, the program encounters SQL0302N error...
1
by: Jean-Luc M. | last post by:
Hi, On first DB2 install, what's the default base to test connect with JDBC please ? Thanks, -- Jean-Luc M.
1
by: Chris M. Gamble | last post by:
I recently upgraded an application from postgresql 7.4.2 to 7.4.5, and now I am having timezone nightmares. I checked on the old server, and found that in the postgresql.conf, the timezone was set...
0
by: Ninja Zombie | last post by:
Hi all, is there maybe a property on the JCC driver which, when set, will convert the selected TIMESTAMP attribute to my local timezone. The database server is in the different timezone than the...
1
by: =?Utf-8?B?VG9uZQ==?= | last post by:
Hi, I need to change a value of an element in an XML file, I have been trying to select the node to edit but can only get as far as component and have to itterate through.. XmlDocument doc =...
7
by: natG | last post by:
Using the IBM Universal JDBC (Type 4) driver; Can one specify a default schema as part of the url? Some application servers do not allow sending a default sql command upon connection, so I can't...
11
by: cybervigilante | last post by:
I can't seem to change the include path on my local winmachine no matter what I do. It comes up as includ_path .;C:\php5\pear in phpinfo() but there is no such file. I installed the WAMP package...
0
by: AqD | last post by:
Hi all! I just noticed on windows (2003; php 5.2.5) the LOCAL timezone is set to UTC by default. I have never experienced this on linux before... I digged the manual and found this: """...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.