Hi to all of you.
I need an help about SQL Function IFNULL
I need to test if a date is NULL, if not i need to obatin that date in the field, otherwise i need to put a dummy date..
Ex. IFNULL (prezzi.duc , '2000-01-01')
I write from Italy , is it correct to put '2000-01-01' to have 01/01/2000 or what do i need to write ???
I encounter error cause i have some records with prezzi.duc FIELD containing NULL dates.
I need to force NULL in something else.
Can you help me please ???
Have a good day.
Regards.
I need an help about SQL Function IFNULL
I need to test if a date is NULL, if not i need to obatin that date in the field, otherwise i need to put a dummy date..
Ex. IFNULL (prezzi.duc , '2000-01-01')
I write from Italy , is it correct to put '2000-01-01' to have 01/01/2000 or what do i need to write ???
I encounter error cause i have some records with prezzi.duc FIELD containing NULL dates.
I need to force NULL in something else.
Can you help me please ???
Have a good day.
Regards.