var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cast Question - Converting Datetime into Date
I knew that the Function Cast can do this but I tried a lot and I dont want to use the MONTH, YEAR, DAY function.
I have a smalldatetime field with a value of this 12/18/2004 4:02:00 PM
I just like to see it like this 12/18/2004
Hope you can help me up. Thanks.
Got Books Online (BOL)?
declare @val datetime
set @val='12/18/2005 11:00:00'
select @val, convert(char(10),@val,101)
I have it here.. Thanks a lot....Sometimes, when you have a lot of things in your mind, you cant see exactly the answer which is sometimes in your face already.
Originally Posted by Brett Kaiser