if dt_date is string i think this may work
select * from account where Convert(datetime,dt_date)='02/02/2005'
or
to get exact result without errors
SET DATEFORMAT mdy --> month/day/year example 1/30/2005 or 01/30/05 or.... etc
SET DATEFORMAT dmy --> day/month/year 30-12-2005 .......etc
so the complete query
SET DATEFORMAT dmy
select * from account where Convert(datetime,dt_date)='02/02/2005'
or 2-2-2005
try whatever you want
thks :)
rkmnm <[EMAIL PROTECTED]> wrote:
hi
please tell me how to change string field to date field in where
clause i am writing this query
select * from account where cdate(dt_date)="02/02/2005"
if any suggestion please help me
thanks ravi
Mostafa A.Basha
Start your day with Yahoo! - make it your home page
SPONSORED LINKS
| Programming languages | C programming language | Computer programming languages |
| Java programming language | C programming language | History of computer programming language |
YAHOO! GROUPS LINKS
- Visit your group "Microsofts_C_Sharp" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
