Tuesday, February 14, 2012

Date1 = Date2 ?

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?

No comments:

Post a Comment