• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

How to insert null in datetime field

How to insert null in datetime field, I want to pass it as a parameter from front end.
and then how to read null date value from table.
0
searchsanjaysharma
Asked:
searchsanjaysharma
  • 2
  • 2
1 Solution
 
appariCommented:
from front end to pass null value to db assign dbnull.value to the parameter value.
for more help can you post existing code?
0
 
searchsanjaysharmaAuthor Commented:
It worked, Now how to retrieve it.
Covertaken and coverdate are two fields.

select Covertaken+'-'+convert(varchar,coverdate,106) from emp
not works if coverdate is null
0
 
appariCommented:
try this

select Covertaken+isnull('-'+convert(varchar,coverdate,106),'') from emp
0
 
searchsanjaysharmaAuthor Commented:
ok
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now