View Single Post
  #21 (permalink)  
Old 07-06-2007, 05:19 AM
Nextasy Nextasy is offline
Active Member
 
Posts: 42
Default

I found the mistake in the format of the datum.

here is a part of my sql list file, which the script created:

Quote:
update mail_item set date=unix_timestamp('2005-07-27 10:36:56') where id=3025;
update mail_item set date=unix_timestamp('Mon, 4 07 2005 09:59:05 +0200 (CEST)') where id=3026;
The first entry will be correct importet into the database, the second not. So, my sed skill isnt good and i hope, that someone could help my to figure out, how i can change the format from "Mon, 4 07 2005 09:59:05 +0200" to "2005-07-04 Mon, 4 07 2005 09:59:05 +0200" via sed

thanx in advance
Reply With Quote