MS SQL Server - Re: insert only date

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: insert only date

Tibor Karaszi

2005-07-27, 8:23 pm

Yes (see Vyas' response), but a time portion will still be stored. See
http://www.karaszi.com/SQLServer/info_datetime.asp for more information.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"JIM.H." <JIMH@discussions.microsoft.com> wrote in message
news:27606F13-199E-45F1-9E12- B1232845A907@microso
ft.com...
> Hello,
>
> In a stored procedure;
>
> INSERT INTO myTable(myDate) VALUES (@myDate)
>
> This inserts data and time, is there any way I can only insert date portion
> of DateTime
> Thanks,
>

Sponsored Links