My dates are all screwed up. Dates are showing up as 0099 instead of 1999 and 0000 or 0001 and then sometimes 2001 for newer links, what's going on? Is there a y2k problem, or in the import?

Hmmm I've never experienced any problems. The only thing I can think of is that you could check:

Setup > Date Options and check all is well in there.

Other than than I don't know what to say. Another Links SQL user or staff member may be able to shed some more light....

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Hi,

Sounds like the import. Were you using a custom date format in Links 2.0? If you were, you'll need to modify convert_date() in Links/Import/L2S2.pm so it can take your date format and convert it into yyyy-mm-dd format that mysql recognizes.

Cheers,

Alex

--
Gossamer Threads Inc.

I don't think I had any special date format, never touched the date field...

I already went live and only noticed this later so how can I import again without losing changes like all the dead links I killed?

Is there any way to do a select and turn any 0099, 0000, 0001 into 1999, 2000, 2001? The date seems to be including the year and date together...sigh.

browsing the table the date looks like this in mysqlman

0098-12-15

how does it look for others?

maybe i didn't word the question right. The Add_Date and Mod_Date field looks like

"0099-07-11"

Is there an sql statement that would select all records with "0099" in Add_Date field and modify just those 4 charaters with "1999"?

Thanks.

I think you have to select the links like this:

SELECT Add_Date FROM Links WHERE Add_Date LIKE "0099-%"

Then you have to do a little bit of manipulating the selected strings by changing the first two charcters from 00 to 19 .
After that, you have to UPDATE the selected Link in the Links-table.

Hi,

This one should do it:
UPDATE Links SET Add_Date = REPLACE(Add_Date, "0099", "1999");



Andreas
http://www.archaeologie-online.de