Incorrect date format? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Incorrect date format?

Author

Topic

Shane1120
Starting Member

2 Posts

Posted - 2011-05-19 : 12:16:53

Hello,

i work at Charter Communications in the IT security team. every day i get a report that list the top 100 dirty IP address for our customers. i take this data and create an email in outlook and then send it to an email address that is linked with a MySQL 5.0.45 database. the input looks like this when i email it

"24.171.69.55 On DUL 201 15 11 May 2011 04:55:00 24-171-69-55.dhcp.mtvr.il.charter.com"

the problem is that SQL is not pulling the date from the abuse and instead is poulling the date from when i emailed it to the server.

does anybody know a way to make SQL pull the date from the abuse email and not the day that i sent the email?

for example the line mentioned above is one i did today, this is what happens after i email the data to the server

Received: from imp04 ([blank]) by mta62.charter.net
(InterMail vM.7.09.02.04 201-2219-117-106-20090629) with ESMTP
id <20110519155635.PNUX23252.mta62.charter.net@imp04>
for <abus23e@charter.net>; Thu, 19 May 2011 11:56:35 -0400
Received: from mail.chartercom.com ([blank])
by imp04 with charter.net
id lTwb1g00K0LromG04Twbs8; Thu, 19 May 2011 11:56:35 -0400
Received: from unknown (HELO KSTLMEXHTP02.CORP.CHARTERCOM.COM) ([192.168.31.32])
by mail.chartercom.com with ESMTP; 19 May 2011 10:56:34 -0500
Received: from .CORP.CHARTERCOM.COM ([blank]) by
.CORP.CHARTERCOM.COM ([blank]) with mapi; Thu, 19 May
2011 10:56:34 -0500

but instead of putting 11 May 2011 into a new trouble ticket it imputs the day i sent the data which is 19 May 2011 ??

please any help would be great

Shane1120
Starting Member

2 Posts

Posted - 2011-05-19 : 12:18:53

sorry for the edit i had to go back and delete the IP address for security reasons