Subject | Re: NULL Date values |
---|---|
Author | jeff_j_dunlap |
Post date | 2007-09-10T16:02:49Z |
Here is a code snippet showing how I am obtaining the date values, null
or otherwise:
SELECT DateToStr(INITIALCONTACTDT, '%m.%d.%y') FROM LEADS WHERE IDNO
= '325'
if (st->Fetch())
st->Get(1, sInitialContactDt);
sInitialContactDt contains the date if available. If the date is NULL,
rFunc's DateToStr function returns 11.17.4294967254
I am really confused why DateToStr() returns the value above when it
encounters a NULL date. Am I not supposed to allow NULL date values
into FB?
Please advise,
Jeff
or otherwise:
SELECT DateToStr(INITIALCONTACTDT, '%m.%d.%y') FROM LEADS WHERE IDNO
= '325'
if (st->Fetch())
st->Get(1, sInitialContactDt);
sInitialContactDt contains the date if available. If the date is NULL,
rFunc's DateToStr function returns 11.17.4294967254
I am really confused why DateToStr() returns the value above when it
encounters a NULL date. Am I not supposed to allow NULL date values
into FB?
Please advise,
Jeff