How to convert GMT Date to Local Time date? Options

[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