General information
Forum:
Microsoft SQL Server
Title:
CONVERT to Datetime
I have a table that has the following columns:
nlUnit int
tDate nvarchar(10)
ndAmount float
I want to retrieve a recordset that converts the tDate to a datetime. I am using the following to do so:
SELECT nlUnit, CONVERT(datetime, tDate) AS dDate,ndAmount
My issue is that I want to also use a where statement like
WHERE (ndAmount >= 50.00) and (dTradingDate BETWEEN '4/1/03' AND '4/15/03')
This is not working. I am retrieving my recordsetand then applying a date filter to it.
Does anyone know the correct syntax for the above. If not, is there a better work-around?
Thanks in advance.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only