Posted by kashifsulemani on 11/17/05 22:34

we have a table like this

OrderNo OrderDate
1 2005-11-04 01:12:47.000
2 2005-11-19 04:26:54.000
3 2005-11-16 11:03:23.000
4 2005-11-21 15:58:37.000
5 2005-11-24 21:45:04.000


what will be the sql query, so that the Result look like this.
only to neqlect the time factor from datetime data type .


OrderNo OrderDate
1 2005-11-04
2 2005-11-19
3 2005-11-16
4 2005-11-21
5 2005-11-24

• Next in forum: Re: Optimizing Stored Procedure with Datetime parameter
• Prev in forum: Re: need help
• Thread view: Simple SQL Query (To Neglect time from DateTime DataType)

[Reply to this message]