Home » SQL & PL/SQL » SQL & PL/SQL » Timestamp in mail generated from oracle is different (oracle 9i)
Timestamp in mail generated from oracle is different [message #569816] Fri, 02 November 2012 00:54 Go to next message
rajesh4851
Messages: 82
Registered: January 2007
Member
Dear friends,
I have found there is a wearied of email generated from my database.

I have the data base server located in US (estern time) and the sysdate in the database is AUSTRALIA (AEST). But i am working from india (IST).

I have one procedure, which will send email to some recipients once the job is done. It is using UTL_SMTP for sending the email from database.

Now problem is, the email i got from this procedure has a different timestamp which is NOT matching to any of the times:

Time in Mail : 2-Nov-2012 9.56 PM

IST Time : 2-Nov-2012 10.56 AM

Easter Time : 2-Nov-2012 01.30 AM

AEST Time : 2-Nov-2012 4.30 PM


Pls suggest what could be the reason?

Regards,
Rajesh
Re: Timestamp in mail generated from oracle is different [message #569824 is a reply to message #569816] Fri, 02 November 2012 02:02 Go to previous message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle Session timezone?
Oracle database timezone?
See time zone functions in Database SQL Reference.

Regards
Michel
Previous Topic: Transpose
Next Topic: Query
Goto Forum:
  


Current Time: Fri Apr 18 04:13:34 CDT 2014

Total time taken to generate the page: 0.08959 seconds