Help - Search - Members - Calendar
Full Version: How to convert GMT Date to Local Time date?
Oracle DBA Forums > Oracle > Oracle Forum
carlinodba
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
burleson
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.