diff options
Diffstat (limited to '')
| -rwxr-xr-x | OpenSim/Data/PGSQL/PGSQLGroupsData.cs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs index 6ef576b..f398256 100755 --- a/OpenSim/Data/PGSQL/PGSQLGroupsData.cs +++ b/OpenSim/Data/PGSQL/PGSQLGroupsData.cs | |||
| @@ -435,7 +435,7 @@ namespace OpenSim.Data.PGSQL | |||
| 435 | 435 | ||
| 436 | using (NpgsqlCommand cmd = new NpgsqlCommand()) | 436 | using (NpgsqlCommand cmd = new NpgsqlCommand()) |
| 437 | { | 437 | { |
| 438 | cmd.CommandText = String.Format("delete from {0} where \"TMStamp\" < CURRENT_DATE - INTERVAL '2 week'", m_Realm); | 438 | cmd.CommandText = String.Format("delete from {0} where \"TMStamp\"::abstime::timestamp < now() - INTERVAL '2 week'", m_Realm); |
| 439 | 439 | ||
| 440 | ExecuteNonQuery(cmd); | 440 | ExecuteNonQuery(cmd); |
| 441 | } | 441 | } |
| @@ -461,7 +461,7 @@ namespace OpenSim.Data.PGSQL | |||
| 461 | 461 | ||
| 462 | using (NpgsqlCommand cmd = new NpgsqlCommand()) | 462 | using (NpgsqlCommand cmd = new NpgsqlCommand()) |
| 463 | { | 463 | { |
| 464 | cmd.CommandText = String.Format("delete from {0} where \"TMStamp\" < CURRENT_DATE - INTERVAL '2 week'", m_Realm); | 464 | cmd.CommandText = String.Format("delete from {0} where \"TMStamp\"::abstime::timestamp < now() - INTERVAL '2 week'", m_Realm); |
| 465 | 465 | ||
| 466 | ExecuteNonQuery(cmd); | 466 | ExecuteNonQuery(cmd); |
| 467 | } | 467 | } |