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.