convert function in SQL.

Question

0.00/5 (No votes)

See more:

Dear Team,

I have the Select Query as follows:

SQL

select count(c.ID) as [RECORDCOUNT], U.NETWORKID from CUSTOMERLOANDATA C (nolock)
Inner Join USERMASTER U (nolock) on U.Id = C.QCUSERID
where convert(varchar(10),C.UpdatedON,120) = CONVERT(VARCHAR(10), GETDATE(),120)
AND
 where isnull(c.QCPRocessed,0) = 1
group by U.NETWORKID
order by U.NETWORKID

I cant find the where condition .What does it mean ??

where convert(varchar(10),C.UpdatedON,120) = CONVERT(VARCHAR(10), GETDATE(),120)

Please Guide me.
Thanks
Harshal

Posted 16-Apr-14 5:47am

R Harshal

Add a Solution

Comments

Richard C Bishop 16-Apr-14 12:17pm

What do you mean you can't find the "WHERE" condition. Look at the query, it exists where the word "WHERE" is.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bob@work · Accepted Answer · 2014-04-16T06:19:00

http://msdn.microsoft.com/en-us/library/ms187928.aspx[^]

Never had a reason to use SQL's "convert", but apparently it is forcing the dates into a common format (varchar) with a length of 10, "04/15/2014". This ensures that the where statement is comparing identically formatted dates.

it's selecting records that were updated on a particular day determined by the GETDATE() function and matching the dates as a 10-character string.

convert function in SQL.

1 solution

Solution 1

Add your solution here

Preview 0

convert function in SQL.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us