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
Messages: 89
Registered: January 2007
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?

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: 65152
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.

Previous Topic: Tricky SQL Issue...
Next Topic: convert column into row
Goto Forum:

Current Time: Tue Aug 22 06:11:29 CDT 2017

Total time taken to generate the page: 0.04445 seconds