|
Home > Archive > MS SQL Server > July 2005 > 2006-07-28 00:00:00
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 |
2006-07-28 00:00:00
|
|
| Fernand St-Georges 2005-07-28, 7:23 am |
| This is the result I get in Word as I handle a document that merges data
from the database. The field ĞDate_Fin_Membreğ returns me this result
even if the query stipulates
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success. I just need the date not the following
hours, minutes and seconds.
thanks
| |
| manish19@gmail.com 2005-07-28, 7:23 am |
| You might be using CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101)
only for checking in where clause, you will have to specify the same in
Select columns as well.
something like this:
Select
CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101) from XYZTable
Where
dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101))
Regards,
| |
| Fernand St-Georges 2005-07-28, 7:23 am |
|
Thanks, it solved my problem.
*** Sent via Developersdex http://www.droptable.com ***
|
|
|
|
|