Hi
I'm wearing out on this...
I can't get even a workaround to work with this date. This has been working more or less (do-able) an my own machine but not now on my server. Everything else is pretty nice.
Trying to get a date of any kind as long as I can even forceably change it.
How exactly should I set up my date column?
I'm doing...
alter table assign modify date_last_visited date not null (should be null?) default "2001-00-00" (and a million variations);
No matter what I do I get 0000-00-00 and it refuses to change from other scripts that try to alter it that used to work on my own machine. No matter what I do it won't change.
I don't care if it initially says 0000-00-00 that's fine in this case but I need to be able to change it at will. Why won't it change?
My back is so sore I can barely sit up from dealing with this.
Thanks!
Richard
I'm wearing out on this...
I can't get even a workaround to work with this date. This has been working more or less (do-able) an my own machine but not now on my server. Everything else is pretty nice.
Trying to get a date of any kind as long as I can even forceably change it.
How exactly should I set up my date column?
I'm doing...
alter table assign modify date_last_visited date not null (should be null?) default "2001-00-00" (and a million variations);
No matter what I do I get 0000-00-00 and it refuses to change from other scripts that try to alter it that used to work on my own machine. No matter what I do it won't change.
I don't care if it initially says 0000-00-00 that's fine in this case but I need to be able to change it at will. Why won't it change?
My back is so sore I can barely sit up from dealing with this.
Thanks!
Richard