Feed the creative machine

Wednesday, November 30, 2005

Compare dates in SQL server

Comparing dates in SQL server. This task took me lot of time. I was unable to get the syntax right. In the end my wife helped me out. Thanks to her.

CONVERT(VARCHAR(10), table.StartDate,120) <= CONVERT(varchar(10), GetDate(),120)

:)

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home