Hi,
Many a time with all the data we want to store the current date time for reference purpose. If your application is going to work with more than one country than its best to store the date time in UTC (GMT) format. With difference database the way to get the current UTC date time is different. Here is a list of way to do the same for different database.
Oracle 9i and above
select new_time(sysdate,'EST','GMT') into Result from dual;
Don’t forget to change EST with the current time zone of the database.
MS SQL 200 and above
GETUTCDATE()