Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_SMTP and "E-mail sent time"
"Sander Goudswaard" <sander_at_example.com> wrote in message
news:Xns9550738F72D8Asnafuexamplecom_at_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
No luck yet. I guess it adds the difference between server time + GMT while sending the mail.
thanks and regards,
DGK
Received on Wed Aug 25 2004 - 06:20:57 CDT