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.

• Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
• Discuss Programming Problems and Freshers Jobs related issues here.
• Discuss Final Year Project Ideas here.

Script Name WeekDayDiff Function A function I recently had need of to calculate the difference in days between two weekday dates, without counting days which fall on a weekend. 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 .... 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.

Google Search