Add to Favorites    Make Home Page 14484 Online  
 Language Categories  
 Our Services  

ASP » Tips and Tutorials » Date and Time » Using DateDiff function in SQL Statement

A D V E R T I S E M E N T

Search Projects & Source Codes:



Title Using DateDiff function in SQL Statement
Platform WinNT/2000/2003
Price 0
Author Visit Author Website
Website Visit Website of - Using DateDiff function in SQL Statement
Category ASP » Tips and Tutorials » Date and Time
Hits 663
Description 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 ....

A D V E R T I S E M E N T




Google Groups Subscribe to SourceCodesWorld - Techies Talk
Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.


Scripts Related to - Using DateDiff function in SQL Statement

Script Name

Using GetDate Function in an SQL Statement

This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.

Returning Month of Date in an SQL Table

This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement

Time based Greeting

This sample ASP code can be used to give your visitors a time-based greeting, for instance if it's 9:00am your message can say "Good Morning".

Time Formatting with Now()

I will teach you how to use the Now() command and display it 24 times and all of them be different. Example: use the Now() command and get Monday, 1 July, 2003.

Playing With Dates

There are several different ways of displaying dates. You can also add and subtract from them as well. Using the FormatDateTime function we can display dates in any manner.

Playing With Times

There are several different ways of displaying times. Using FormatDateTime and DatePart functions we can manipulate the time in many different ways.

Compare dates

Self explaining sort scripts to compare dates. You may use them to display your age, time period fromm a given date or happening etc. (DateDiff, Timer)

Displaying Date, Time, and Text

Shows the basic methods to display date, time and text in a ASP script. Examples on different ways to display the date and time presented.

Date Last Modified ScriptWriter

The author writes "Many places on the web feature the date that the current document was last modified on. Rather than changing the date manually, using a FrontPage WebBot, or targeting the document by writing it directly into the script, let the server ask the document for the info and it will tell you. This scriptwriter will output code that can be placed on any .asp document on your server and will display the date and time it was last modified in a number of varieties."

Dates & Times - Usage & Formatting

Dealing with dates, especially in anything other that US standard format, can be a challenge. This tutorial discusses the scripting needed to handle them properly for a range of applications. It also lists reference for each date/time function.

Google Search

Google

Source Codes World.com is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2019 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/Using-DateDiff-function-in-SQL-Statement-2335/Default.asp


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review


 Advertisements