DateTime Stamp

, ,
1

hi ,
I need to insert Null Value in the Variable (DateTime Stamp)
when i am sending the value 0000/00/00 00:00:00 (yyyy/MM/dd hh:mm:ss)
its throwing me that it cannot insert the year 2 in database.
I tried to create the null date using dateTimeFormat Service in webMethods 6.1.
i/o parameters :-
instring : 00000000(mmddyyyy)
current pattern : mmddyyyy
newpattern : yyyy/mm/dd hh:mm:ss

i am getting Output : 0002/00/31 12:00:00
but my required output is : 0000/00/00 00:00:00

Does any one share ther experiences …
how to insert null Date in variable(Type DateTime Format )

Thanks,

2

Easiest thing to me is to have the DBA set the table default value to either null or the specified pattern that you mention in your post.

You don’t mention your db type that you are using (SQL2000, oracle, etc.)

If they cannot do it, perhaps it is a db limitation?

Ray

3

Or at least make it allow Null and then just don’t insert it.
That being said most date formats would not accept 00 as either a month or day.

select to_date(‘0000/00/00’,‘YYYY/MM/DD’) from dual
*
ERROR at line 1:
ORA-01843: not a valid month