|
|
|
|
SQLCE profs please help !!!!
I have a table 'test' with a column 'testdate' as nvarchar(50).
The data this table are datetime values:
10-01-2005
11-01-2005
etc
I want to search records in this table, like they are datetime formats, no
string formats (i known, i had to make the 'testdate' column a 'datetime')
so expressions like: < 10-01-2005
this query doesnt work:
select * from test where convert(datetime,testdate,103) < '11-01-2004'
any suggestions?????
you can email me at: krikkew(removethis)@viadata.nl
Fri, 14 Jan 2005 05:45:03 -0800
"=?Utf-8?B?d2lsY28=?="
|
Re: SQLCE profs please help !!!!
"Does not work" gives an error or does not return any rows?
If the query is correct, I suspect your problem is date format.
Do you use dd/mm/yy or mm/dd/yy ?
Fix the format or check and set correct regional setting on the device.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Fri, 14 Jan 2005 11:09:39 -0800
chora
|
|