Help - Search - Members - Calendar
Full Version: How to convert GMT Date to Local Time date?
Oracle DBA Forums > Oracle > Oracle Forum
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.


Hi Carlino,

>> convert GMT

This is done with "Oracle globalization":

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

See here, complete notes:
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-2016 Invision Power Services, Inc.