The following bug has been SUBMITTED.
======================================================================
http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000211
======================================================================
Reported By: frerichs
Assigned To:
======================================================================
Project: DBMail
Bug ID: 211
Category: IMAP daemon
Reproducibility: always
Severity: minor
Priority: normal
Status: new
======================================================================
Date Submitted: 27-May-05 17:58 CEST
Last Modified: 27-May-05 17:58 CEST
======================================================================
Summary: date_slq2imap does not output RFC compliant dates
(probably DB dependant)
Description:
The dates are not in fact converted to the date format mandated in RFC
2822, ie
date-time = [ day-of-week "," ] date FWS time [CFWS]
day-of-week = ([FWS] day-name) / obs-day-of-week
day-name = "Mon" / "Tue" / "Wed" / "Thu" /
"Fri" / "Sat" / "Sun"
date = day month year
year = 4*DIGIT / obs-year
month = (FWS month-name FWS) / obs-month
month-name = "Jan" / "Feb" / "Mar" / "Apr" /
"May" / "Jun" / "Jul" / "Aug" /
"Sep" / "Oct" / "Nov" / "Dec"
day = ([FWS] 1*2DIGIT) / obs-day
time = time-of-day FWS zone
time-of-day = hour ":" minute [ ":" second ]
hour = 2DIGIT / obs-hour
minute = 2DIGIT / obs-minute
second = 2DIGIT / obs-second
zone = (( "+" / "-" ) 4DIGIT) / obs-zone
But instead pops a time zone offset on the end of the date as passed by
SQL, and leaves it at that. In my case, I am using MYSQL and the date ends
up looking like:
2005-05-26 12:34:56 +0100
======================================================================
Bug History
Date Modified Username Field Change
======================================================================
27-May-05 17:58frerichs New Bug
27-May-05 17:58frerichs File Added: dbmail-2.0.4-fixdate.patch
======================================================================
