topic Re: Date field as 'NULL' in Application Development and Automation Discussions

Date field as 'NULL'

Former Member — Tue, 26 Aug 2008 17:28:20 GMT

Hi!

I want to insert a 'NULL' value in date field in database.

If I leave the field blank it inserts '00000000'.

If I specify a space, it inserts ' / / '

How do I insert null for Date. Other programs pick up this Null value, so I want to insert it as Null only.

Thanks.

Edited by: Nikhil DOZ on Aug 26, 2008 10:58 PM

Re: Date field as 'NULL'

Former Member — Tue, 26 Aug 2008 17:29:37 GMT

initial value for date is '00000000'.

Re: Date field as 'NULL'

Former Member — Tue, 26 Aug 2008 17:31:03 GMT

I want it stored as NULL, because there is another program which check date = NULL in select statement.

How can I do this?

Re: Date field as 'NULL'

Former Member — Tue, 26 Aug 2008 17:34:44 GMT

Hi,

Try to have the char datatype for that date field to have the NULL value. Have the lenght of the field as CHAR(8) or CHAR(10) for your requirement. Here we can have spaces ot NULL as the field value.

We cant have NULL value for the field whose datatype is of DATE or DATS type. This is posible in Oracle and other databases.

Regards

Lekha

Re: Date field as 'NULL'

karan007 — Wed, 07 Dec 2022 14:18:32 GMT

Hi,

my_element->set_attribute_null(

EXPORTING

name = `<Attribute_Name>` ).