var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Getdate() with no time associated
Is there a command that will let me set getdate() a in a smalldatetime field so that the there is no time associated with it?
For example, I have a table that I want to load the date a user does an action. If I use getdate() I'll get a value such as 5/25/2006 08:26:56.340, whereas I would just like a value 5/25/2006.
I can work it out by doing the following: select (datename(month,getdate())+'-'+datename(day,getdate())+'-'
However it seems to me that there should be a simpler way.
well, i dunno if it's simpler, but this is a lot more efficient --
Towards the bottom of this article is an explanation on the why and how
EDIT - how about I post the article link eh?
ur codings are working excelent.
Thanks to you both
That does seem more efficient (I knew there had to be a better approach). And thanks for the link to the article.
fabulous link, pootle, thanks