popular collection of scripts for all

• Categories
• Tags

Using GetDate Function in an SQL Statement Hits: 111 ***** 3.5 Comparing Dates in ASP Hits: 83 ***** 4.5 VBScript Examples : DatePart Function Hits: 70 ***** 4.0 Insert Date into Access Database Hits: 66 ***** 3.5 This function is very useful, In this tutorial we will DatePart function is a very When inserting a date into an if you wish to get date of compare dates. We will use useful function to get the a Access database you should current SQL server date and DateDiff function. You may part of a date. You may get use the format YYYY-MM-DD. time. You may use this compare any two valid dates year, month, day of year .. Our function AccessDate function to fill some rows calculation year, day, etc. of a specific date. returns a date in YYYY-MM-DD automatically with current month, week, minute ans   format. When working with a time or using with DateDiff seconds.   date in Access always use function to return the     the # delimiters in your SQL number between current time.     statement. Date: Feb, 10 2004 Date: Mar, 02 2006 Date: Apr, 12 2004 Date: Dec, 13 2005

Formating Date and Time Hits: 49 ***** 1.0 Returning Month of Date in an SQL Table Hits: 39 ***** 0.0 Converting normal Date into RFC-822 Format Date using ASP Hits: 37 ***** 4.0 Date Last Modified ScriptWriter Hits: 37 ***** 0.0 In this source code, you may This is an useful but not Have you ever wanted to The author writes "Many see how can you display date known functions. If you wish format a date in your ASP places on the web feature in diffrent formats. This to learn month of date pages (using VBScript) to the date that the current simple ASP code displays stored in a database, you conform with RFC-822? These document was last modified current time in short, long may use this function are required for various on. Rather than changing and regional settings. placing in a 'SELECT' sql things but in particular the date manually, using a   statement they are required format for FrontPage WebBot, or     dates in RSS feeds. While I targeting the document by     was producing some RSS feeds writing it directly into the     I couldn't find any script, let the server ask     functions that converted ASP the document for the info     dates to the required and it will tell you. This     formats so I created the scriptwriter will output     following functions to do it code that can be placed on     for you any .asp document on your       server and will display the       date and time it was last       modified in a number of       varieties." Date: Feb, 19 2004 Date: Feb, 10 2004 Date: May, 27 2005 Date: Jan, 03 2002