I have a table in SQL. I have the following query against said table:
SELECT coalesce(setdate,'') as datetime from error WHERE fault = 1
Now I can take SQL manager and look at the table and the first 2 rows of data have an actual value in them. The third row has a NULL in it. However when I use this query to generate data for a table in FPMI, the row with NULL in it gets a date of Jan 1st 1900. And a time of 12:00:00am
Can someone explain what is happening here?
Thanks and have a great day.
PS what I want the display to do is show the first two time stamps and because the third is a null display a blank not some obscure date.