Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How to convert GMT Date to Local Time date?
carlinodba
post Sep 16 2011, 10:46 AM
Post #1


Member
**

Group: Members
Posts: 10
Joined: 8-September 11
Member No.: 45,855



Hi, I need to convert the type of GMT to Local time, during data entry.

I have a source table and a target table.

To make the insert get the most value, I have no problems:

insert into destination (SELECT * FROM WHERE source pointnumber = (SELECT MAX (pointnumber) FROM source));

But since times are different between the tables, I want to convert the data obtained to GMT -4:30 Time (Caracas - Venezuela), before inserting it.

They may help me?, I can use a function? have any idea how to do it?

Thank you very much, in advanced.

Regards

Carlinodba
Go to the top of the page
 
+Quote Post
burleson
post Sep 17 2011, 08:25 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,329
Joined: 26-January 04
Member No.: 13



Hi Carlino,

>> convert GMT

This is done with "Oracle globalization":

http://www.dba-oracle.com/t_time_display_mismatch_utc.htm

Yes, you can cionvert dates to anywhere you like using the date bifs:

http://www.dba-oracle.com/t_oracle_current_timestamp.htm

http://www.dba-oracle.com/bk_oracle_timezone.htm



See here, complete notes:

http://www.dba-oracle.com/t_oracle_dayligh..._conversion.htm

http://www.praetoriate.com/oracle_tips_builtin_functions.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th July 2014 - 09:33 PM