How i do this :
... WHERE (id_pessoa = 1) AND (CONVERT(VARCHAR(12), Data) = CONVERT(CHAR(12), '04/02/2002'))
in format (ddmmyyyy)What is data? Is it a date?
Why do you use varchar(12)
then
and data = convert(datetime,'04/02/2002',103)
if it's the date in dd/mm/yyyy format then you don't need to convert - just use the left(data,10)
What is in format ddmmyyyy?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment