Hi,
I have one table with data that has two datetime columns. I also have an empty table that is i copy of the first (ie identical design) + one column, that I want to move some rows to.
When I do the insert into the empty table the datetime fileds are converted from '2004-01-01' to 'Jan 1 2004 12:00AM' WHY!!!
I hate this kind of problems... I haven't told it to convert, and besides it adds a time too...
Anyone got a solution or explanation for this, please?I don't think it's been converted. It's just the way you display it. The value stays the same.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment