473,394 Members | 1,746 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,394 software developers and data experts.

Timezone Conversions - URGENT

Hi all,

i have a doubt regarding time conversions between different timezones.

say presently i have a Time which is to be converted from 'PST' to 'UTC'

and the same with others say 'PST/PDT,MST/MDT,EST/EDT' to UTC.

can this be done with any oracle functions, please post me the sql statements if any of u have.

thnx in advance
Oct 24 '06 #1
5 6882
arg
11
I think NEW_TIME is the function you are looking for. Which version of oracle?
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10749/ch4datetime.htm


Hi all,

i have a doubt regarding time conversions between different timezones.

say presently i have a Time which is to be converted from 'PST' to 'UTC'

and the same with others say 'PST/PDT,MST/MDT,EST/EDT' to UTC.

can this be done with any oracle functions, please post me the sql statements if any of u have.

thnx in advance
Oct 24 '06 #2
I am using Oracle 9i,

can we specify directly say i have 'PST' time, now convert it to 'UTC'...

can this be done in sql statements?
Oct 25 '06 #3
Hi

Try This May help U!
UTC Time Zone Same as GMT time Zone.

select to_char(new_time(sysdate,'PST', 'GMT'), 'MM/DD/YY HH:MI AM') FROM dual;


With Regards,
Captain
Oct 25 '06 #4
Hi

If U Want More Information to visit this site helpfull for Date Functions.

http://www.unix.org.ua/orelly/oracle/prog2/ch12_02.htm

With Regards,
Captain
Oct 25 '06 #5
SDBA
5
Hi,

Try using the following link...
http://www.devx.com/dbzone/Article/30501/1954?pf=true

This cud help you...

SDBA
Oct 25 '06 #6

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

Similar topics

7
by: Jim Davis | last post by:
I'm (still) working on an ISO 8601 date parser. I want to convert at least the formats described here: http://www.w3.org/TR/NOTE-datetime Well.. I've got most of it working (via RegEx's) good...
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...
2
by: David Garamond | last post by:
When a timestamp string input contains a timezone abbreviation (CDT, PST, etc), which timezone offset is used? The input date's or today date's? The result on my computer suggests the latter. #...
13
by: Bruno Wolff III | last post by:
Recently there has been some discussion about attaching a timezone to a timestamp and some other discussion about including a 'day' part in the interval type. These two features impact each other,...
3
by: asanford | last post by:
I want to create a web service that allows the caller to pass a DateTime to the web service (that is, create a web method such as void MyWebMethod(DateTime dt).) However, I want to be able to...
0
by: blazerguns | last post by:
Hi, Iam using SetTimeZoneInformation to set time. It works ok that is my system clock in the taskbar is updated. But when i call GetLocalTime it shows the time of my previous timezone. I think...
10
by: =?Utf-8?B?QXhlbCBEYWhtZW4=?= | last post by:
Hi, disassembling following expression I noticed that the implicit conversion between int and decimal appears to be performed at runtime. Why? TIA, Axel Dahmen void Main() {
2
by: =?Utf-8?B?Sm9ubnk=?= | last post by:
I have an ASP.NET 2.0 C# web application that is contacting an Exchange server using WEBDAV. It allows the users to look up appointments for a future date. The problem I have is determining the...
5
by: Ivan Velev | last post by:
Hello, Minimal example below - it gives me different output if I comment / uncomment the extra time.mktime call - note that this call is not related in any way to main logic flow. When...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.