Using DateDiff function in SQL Statement
You may use DateDiff function in an SQL statement to get the number of date and/or time between two dates. You may calculate days between two different date. The return number of DateDiff function can be year, month, day, hour, minute, second .... An example of using DateDiff function in a real ASP script : <% set cn = server.createobject("adodb.connection") cn.open "Provider=SQLOLEDB;Server=localhost;User ID=SA;Password=;Database=newsTable;" set rc = cn.execute("select datediff(day, pubDate, endDate) from news where newsID = 12") response.write rc(0) %>
Our free applications:
Custom Search
- ASP Chat Box
- Working with Array Remove An Item
- ASPNET Web Counter Free Open Source Code
- Beginning-Ajax-and-ASPNET-35
- How to upload images to mySQL within PHP
- Delete Files Online in ASP
- Video Interview With Roman Strobl
- Custom Paging in ASP Fast And Easy
- Displaying Records From An Excel Database
- Paging Results in PHP
- How to write and use a JavaBean My frst java bean
- Installing Sun Java System Application Server 9.1 in Solaris Zones
- Java SE 6 Performance White Paper
- Converting sceonds to hours minutes and seconds
- What is Ecommerce and the Importance of Ecommerce
- Easy Download Manager Free Version
- ASP Chat Box
- Writing Form Data to Text Files
- Paging Records in JSP
- What is Ecommerce and the Importance of Ecommerce
- Beginning-Ajax-and-ASPNET-35
- How to upload images to mySQL within PHP
- Simple XML RSS Parser
- Counting records in PHP mySQL
- ActiveNews Manager Freeware News Exchange Software
- How to write and use a JavaBean My frst java bean
- Paging Results in PHP
- Free User Registration Form
- A-timesaver-control-GridView
- ASPNET Web Counter Free Open Source Code
- Easy Download Manager Free Version
- ASP Chat Box
- Writing Form Data to Text Files
- Paging Records in JSP
- Beginning-Ajax-and-ASPNET-35
- How to upload images to mySQL within PHP
- Simple XML RSS Parser
- ActiveNews Manager Freeware News Exchange Software
- Counting records in PHP mySQL
- How to write and use a JavaBean My frst java bean
- Paging Results in PHP
- Free User Registration Form
- A-timesaver-control-GridView
- ASPNET Web Counter Free Open Source Code
- Comparing Dates
