Change Date of Links (date added)

[brickholius]

How do I change the date of date added links? I imported over 5,000 links that now say added on 31-Dec-1969.


Thanks!

brickholius

[Hart_House]

you can go into your admin area under alter and run this query.

update idx_link set date = '31-Dec-2004' where date = '31-Dec-1969'

First backup your database by using the built in database backup.

[brickholius]

I'm afraid it did not change the dates.

[Hart_House]

update idx_link set date = replace(date, "1969", "2004")

[brickholius]

No such luck

update idx_link set date = replace(date, "1969", "2004")

[brickholius]

Here is the code givent to me my dody which worked.

update idx_link set date = now(), last_updated = ""