ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Query to select record greater than or equal to Current Date in SQL Server<p>Hi <a class="username" rel="itsme"> itsme</a>,</p> <p>Refer below sample query.</p> <p><span style="text-decoration: underline;"><strong>SQL</strong></span></p> <pre class="brush: sql">DECLARE @tblJob AS TABLE(Id INT, Jobtitle VARCHAR(50), Company_Name VARCHAR(50), Salary VARCHAR(50), Skills VARCHAR(50), Qualification VARCHAR(50), Details VARCHAR(MAX), Experience VARCHAR(50), email VARCHAR(MAX), location VARCHAR(50), Last_Apply_Date DATE, City VARCHAR(50), Age VARCHAR(50) ) INSERT INTO @tblJob VALUES(4,&#39;IT Job&#39;,&#39;company&#39;,&#39;2000&#39;,&#39;Asp.Net C#&#39;,&#39;Graduate&#39;,&#39;Good command on web development in asp.net c#&#39;,&#39;2 year&#39;,&#39;company@gmail.com&#39;,&#39;anand&#39;,&#39;10/12/2019&#39;,&#39;Anand&#39;,&#39;24&#39;) INSERT INTO @tblJob VALUES(6,&#39;IT Jo2&#39;,&#39;company&#39;,&#39;2000&#39;,&#39;Android&#39;,&#39;Graduate&#39;,&#39;Good command on Adnroid app development&#39;,&#39;2 year&#39;,&#39;company@gmail.com&#39;,&#39;anand agriculture university&#39;,&#39;8/30/2019&#39;,&#39;Ahmedabad&#39;,&#39;21&#39;) INSERT INTO @tblJob VALUES(7,&#39;test job&#39;,&#39;company&#39;,&#39;5000&#39;,&#39;Android&#39;,&#39;Masters&#39;,&#39;Good command on Adnroid app development&#39;,&#39;7 year&#39;,&#39;company@gmail.com&#39;,&#39;anand agriculture university&#39;,&#39;8/31/2019&#39;,&#39;Rajkot&#39;,&#39;22&#39;) INSERT INTO @tblJob VALUES(10,&#39;date check job2&#39;,&#39;company&#39;,&#39;13000&#39;,&#39;PHP&#39;,&#39;Masters&#39;,&#39;Good command on web app development&#39;,&#39;2 Year&#39;,&#39;company@gmail.com&#39;,&#39;anand agriculture university&#39;,&#39;8/21/2019&#39;,&#39;Gandhinagar&#39;,&#39;23&#39;) SELECT Skills, Qualification ,Last_Apply_Date FROM @tblJob WHERE CONVERT(DATE,Last_Apply_Date)&gt;=CONVERT(DATE,GETDATE())</pre> <p><span style="text-decoration: underline;"><strong>Output</strong></span></p> <table border="1"> <tbody> <tr> <td><strong>Skills</strong></td> <td><strong>Qualification</strong></td> <td><strong>Last_Apply_Date</strong></td> </tr> <tr> <td>Asp.Net C#</td> <td>Graduate</td> <td>12.10.2019 00:00:00</td> </tr> </tbody> </table>https://www.aspforums.net:443/Threads/144383/Query-to-select-record-greater-than-or-equal-to-Current-Date-in-SQL-Server/https://www.aspforums.net:443/Threads/144383/Query-to-select-record-greater-than-or-equal-to-Current-Date-in-SQL-Server/Wed, 04 Sep 2019 03:57:47 GMT