Re: UTL_SMTP and "E-mail sent time"

I have mine setup to adjust for the GMT and report the time correctly

declare this in your header

p_datestring                  VARCHAR2 (100)
      :=    'Date: '


         || TO_CHAR (SYSDATE, 'MM/DD/RR HH:MI AM')

         || ' '

         || DBTIMEZONE

         || ' '

         || '(GMT'

         || DBTIMEZONE

         || ')';

then reference it in your body. I use UTL_TCP calls instead of UTL_SMTP in my package :

• build the start of the mail message ...
• ----------------------------------- rc := UTL_TCP.write_line (conn, p_datestring);

Check with your smtp server support group and verify the time format the server utilizes, it might be different.

Barry Chase
-MylxHQ Oracle Resource Portal
-http://www.mylxhq.com

On 25 Aug 2004 11:50:30 GMT, Sander Goudswaard <sander_at_example.com> wrote:

>"DGK" <Ganesh.Kamath_at_in.bosch.com> wrote in
>news:cghsn6$b4r$1_at_ns1.fe.internet.bosch.com: 
>
>> No luck yet. I guess it adds the difference between server time + GMT
>> while sending the mail.
>
>Probably a difference between how time zone on OS, and in the database are 
>configured.
>
>You can also leave out the Date header, and leave this up to the SMTP 
>gateway to insert.
>
>Sander