var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how i can use only "date" from datetime data type ?
how i can use only "date" from datetime data type ?
because i want only date not time to be display in my application
how to do that ?
Here is a query.
in that case, you should write the necessary application code to display only the date
Originally Posted by navedjobs
this is not a job for sql
those solutions are fine if you need to use only the date somehow, like to match a particular date value in a column to today's date
but the original poster was looking for how to display only the date in the application
i still think this is not a job for sql
select CONVERT(varchar, getdate() , 101)
Why not use CAST(MyDatetime as Date) instead of converting to a string?
In SQL 2008, there is a new date datatype. Why not use that?