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)
:)
CONVERT(VARCHAR(10), table.StartDate,120) <= CONVERT(varchar(10), GetDate(),120)
:)
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home