how to take only database ?

Mar 28 2011 3:04 AM

i want to take only date in one table in sql server 2005 db.for that when we select datetime as datatype it show it's default time also so what can i do for show only date . & if i want to show the current time (System time ) with date instead of default time what can i do?

Answers (6)

to keep up a score

insert method using database