Hello,
For those interested, to fix dates in postgres this worked for us
(postgresql 7.3.2):
update messages set internal_date = internal_date - ('1 year'::reltime)
where internal_date > now();
Jn
---- Original Message ----
From: Bret Baptist <[email protected]>
To: [email protected]
Subject: [Dbmail] Fix for wrong internal date
Sent: Tue, 30 Dec 2003 08:59:56 -0600
> This code uses the next year of this current week if the last week
of the
> year:
> strftime(timestr, sizeof(timestr), "%G-%m-%d %H:%M:%S", &tm);
>
>
> This code will always use the current year:
> strftime(timestr, sizeof(timestr), "%Y-%m-%d %H:%M:%S", &tm);
>
> You need to go through the dbmail sources and change all strftime
lines to
> look like above, with a %Y, instead of a %G.
>
>
> Command to fix mysql entries.
>
> // It subtracts 1 year from the date in the internal_date column of the
> messages table
>
> UPDATE messages SET internal_date = DATE_SUB(internal_date, INTERVAL
1 YEAR)
> WHERE internal_date > now();
>
>
> --
> Bret Baptist
> Systems and Technical Support Specialist
> [EMAIL PROTECTED]
> Internet Exposure, Inc.
> http://www.iexposure.com
>
> (612)676-1946 x17
> Web Development-Web Marketing-ISP Services
> ------------------------------------------
>
>
> Today is the tomorrow you worried about yesterday.
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
-- End Original Message --
--
Jesse Norell
jesse (at) kci.net
