Discuss "Return Default Date If Null" in the SQL Development forum.

oh that's easy wolffy ... kill the designer. that's always the answer.

__________________
Quote of the Month:
Regret: It hurts to admit when you make mistakes - but when they're big enough, the pain only lasts a second.

Questions to Ponder:
Could it be that all those trick-or-treaters wearing sheets aren’t going as ghosts but as mattresses?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69

I'd have to agree.

Wolffy, in .Net I tried handling the date problem by passing the NULL value from the date field through a constructor of my class which has a Nullable Of DateTime property. Unfortunately, you can't pass a NULL value to a Nullable property for some reason

Anyway, I wanted to handle this via the query that I have to hard code.

However, I've been in touch with some DBA's trying to get this issue resolved.

__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

Join our Folding team: DeveloperBarn Folding

I vote for (e)

Yeah, I tried to use Nullable<Date> as well, and found it to be too big a pain in the fistookis. Went with Date.MinValue where a null was needed. Now, how did I do that...hmmm.

__________________
Wolffy
------------------------
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary.

c'mon just convince your boss to let you kill the db designer
Are you sure it wasn't you

I'd get rid of the null values.
Isn't there anything you can do to fill in the null values?
Something like filling in those values with the actual data?

Once I run into something similar, but fortunately, once I started asking about the hired dates
It so happened that someone had another db where these values were and all I had to do
was import this into the db with nulls and problem solved.

Ask around, who knows, perhaps someone has this data

Okay, so I brought it up during my application demo and the guy who is above all DBA's said, "NULL is bad".

So at least him and I are on the same page. Hopefully we can come up with some solution. One of the databases that my app uses, unfortunately, is not under his control and the lady who is in charge of the data is a complete possessive b!tch. So that's my next hurdle.

So now we know who you're gonna kill lol
Just ask her to create a query using her null values and tell her see if she understands
thru that thick skull of hers that you just can't have a null date of hire