Hi All
I've got a bit of a weird one with mysql and date time fields. When I create
the table:
CREATE TABLE test (
testid tinyint(3) unsigned default '0',
testDate datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
And add a row:
INSERT INTO test (testid, testDate) VALUES("1", "0000-00-00 00:00:00");
Add then run a SELECT:
SELECT * FROM test
I get the expected:
testid,testDate
1,0000-00-00 00:00:00
But when I do the same from coldfusion:
<cfquery name="getTestDate" datasource="xxx">
SELECT * FROM test
</cfquery>
<cfdump var="#getTestDate#">
I get:
TESTDATE,TESTID
0002-11-30 00:00:00.0,1
How is 0000-00-00 00:00:00 getting turned into 0002-11-30 00:00:00.0???
Maddness...
Cheers
Mark
______________
Mark Stanton
Technical Director
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
http://www.gruden.com
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
