Re: UTL_SMTP and "E-mail sent time"

From: Sander Goudswaard <sander_at_example.com>
Date: 25 Aug 2004 09:21:37 GMT
Message-ID: <Xns9550738F72D8Asnafuexamplecom@127.0.0.1>

"DGK" <Ganesh.Kamath_at_in.bosch.com> wrote in news:cghjtj$5hh$1_at_ns1.fe.internet.bosch.com:

> Hello,
>
> I am using UTL_SMTP package to send e-mails. I use TO_CHAR(SYSDATE,
> 'dd-mon-yyyy hh24:mi:ss') to set the date-time of e-mail.
> When the e-mail is received, the "sent time" is not the one that is
> set, it gets changed by few hours. Can anybody help he to solve this?
>

Try:

mesg:= 'Date: ' || TO_CHAR(TO_DATE(sysdate ,

                                  'dd Mon yy hh24:mi:ss' ,
                                  'NLS_DATE_LANGUAGE = American'),
                           'dd Mon yy hh24:mi:ss') || crlf ||
       'From: ' || usrname || ' <' || usraddr || '>' || crlf ||

    'Subject: ' || subj || crlf;

Regards,
Sander Received on Wed Aug 25 2004 - 04:21:37 CDT