Android Question Sqlite null date returns 01/01/1970

[Makumbi]

Please help my

SELECT DISTINCT Names,DESCRIPT,DEBITAMNT,CREDITAMNT,TREF, TRDATE,BAL As Balance FROM Statement

my TRDATE returns 01/01/1970 when is null

Please help me out

 

[Computersmith64]

What SQLite type are you using for TRDATE? Can you post the code that processes the result of the query?

- Colin.

 

[Makumbi]

What SQLite type are you using for TRDATE? Can you post the code that processes the result of the query?

- Colin.

iam using Data type Text

 

[RB Smissaert]

How about doing:

SELECT DISTINCT Names,DESCRIPT,DEBITAMNT,CREDITAMNT,TREF, coalesce(TRDATE, ''), BAL As Balance FROM Statement

RBS

 

[OliverA]

my TRDATE returns 01/01/1970 when is null

Are you sure? How are you retrieving TRDATE from the resultset? Via GetString/GetString2? Another method? If via another method, how are you converting the retrieved value to a date? Also, are you sure you are storing NULLs? Could it be that when storing the date it is stored as '01/01/1970'? You have no code posted (retrieval and display), nor any screenshots of a data dump that we can go by, therefore my various questions.