Re: no SENT date on mail from UTL_SMTP.DATA

On 3 Oct 2006 16:20:57 -0700, vishal.nagarkar_at_gmail.com wrote:

>I have a trigger created in my database where I send an email based on
>some database activity to users. The issue I am facing is some times
>the SENT Date does not show up on the mail. This issue comes up
>randomly. We are using Microsoft Outlook.
>
>Can you tell me if there any specific format in which I have to convert
>the date while sending it to UTL_SMTP.DATA() ; function.

 RFC 822 defines the date format to use, with a slight change made in RFC 1123 for the Y2K issue (recommending 4 digit years).

 http://www.ietf.org/rfc/rfc0822.txt , section 5.  http://www.ietf.org/rfc/rfc1123.txt , section 5.2.14  

 Example: Sun, 06 Nov 1994 08:49:37 GMT

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool