On Sep 3, 2004, at 11:36 PM, James M Doherty wrote:
I have a project that is taking input from another system. I have certain
columns defined as 'Date'
Columns. On input I will get '000000' in this field which causes the insert
to fail. I have read the
docs on default and it is unclear to me if this will work. Does anyone have
experience in solving
this problem. The other alternative I thought of was to write a trigger to
fix it ??
000000 is not a valid date, as you are aware :) This is often solved in the application layer by preprocessing the data, changing 000000 to NULL, for example. You may be able to do some of this preprocessing in the database itself, first loading the raw data into a temporary table and then transforming it before putting it into the desired table.
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
