If you are using oracle as back end for your and some times you will come
across this error message,
"ORA-12154: TNS:could not resolve service name"
This error normally occurs when the Host Name and Port you connect to
oracle server differs. Normally the database and deployment server will be
in different locations. So the ...
Get UTC(Greenwich Mean Time) Date in Oracle
Posted On Monday, June 6, 2011 By Techreceipe.com. Under Oracle
SYS_EXTRACT_UTC function gets the UTC date from the Oracle
And you can execute this function as
SELECT SYS_EXTRACT_UTC(systimestamp) FROM dual;
The output will be like
8/3/2010 2:52:57.269909 PM
And it accepts the systimestamp as the parameter
systimestamp : returns the system date with fractional seconds with time zone of the system on which the
database is resides.
And ...