Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to set Date format in UTL_SMTP
"aru" <arumugam.tp_at_gmail.com> a écrit dans le message de news: 1174389921.659772.72440_at_b75g2000hsg.googlegroups.com...
| Hi,
| I have one strange problem with UTL_SMTP.
|
| I am using the following code to set the date value and format in
| header buffer:
|
| header:= 'Date: '||TO_CHAR(SYSDATE,'fmDy, DD Mon YYYY fxHH24:MI:SS')||
| crlf||
| 'From: '||sender||''||crlf||
| 'Subject: '||subject||crlf||
| 'To: '||recipient||crlf||
| 'CC: '||ccrecipient ;
|
| With this method, the mails sent from database carry SYSDATE of the
| machine where the Oracle Database is running. In my case, database is
| running in India.
|
| People in US complain that they get future-dated mail. Since the
| database is running in India and there is time difference of 12 hr
| 30mins between the regions, this is expected. But when I send mail
| using Java Mail API, I did not have this kind of issue. Anything can
| be done for this???
|
| Help from somebody is highly appreciated.
|
| Thanks,
| Ary
|
Use:
to_char(systimestamp, 'Dy, dd Mon yy hh24:mi:ss tzhtzm')
Then there is the time zone in your date.
Regards
Michel Cadot
Received on Tue Mar 20 2007 - 11:46:38 CDT