popular collection of scripts for all

• Categories
• Tags

Formating Date and Time Hits: 1394 ***** 3.0 Insert Date into Access Database Hits: 1982 ***** 3.0 JScript Examples : setDate Method Hits: 1561 ***** 0.0 Playing With Dates Hits: 428 ***** 0.0 In this source code, you may When inserting a date into an Following example displays There are several different see how can you display date Access database you should usage of setDate method in ways of displaying dates. in diffrent formats. This use the format YYYY-MM-DD. JScript. 'setDate methods You can also add and simple ASP code displays Our function AccessDate sets the numeric date of the subtract from them as well. current time in short, long returns a date in YYYY-MM-DD Date object using local time. Using the FormatDateTime and regional settings. format. When working with a   function we can display   date in Access always use   dates in any manner.   the # delimiters in your SQL       statement.     Date: Feb, 19 2004 Date: Dec, 13 2005 Date: Apr, 20 2004 Date: Jun, 10 2002

Playing With Times Hits: 959 ***** 0.0 Returning Month of Date in an SQL Table Hits: 1861 ***** 3.0 Time Formatting with Now() Hits: 1249 ***** 0.0 Using GetDate Function in an SQL Statement Hits: 3074 ***** 3.5 There are several different This is an useful but not   This function is very useful, ways of displaying times. known functions. If you wish   if you wish to get date of Using FormatDateTime and to learn month of date   current SQL server date and DatePart functions we can stored in a database, you   time. You may use this manipulate the time in many may use this function   function to fill some rows different ways. placing in a 'SELECT' sql   automatically with current   statement   time or using with DateDiff       function to return the       number between current time. Date: Jun, 10 2002 Date: Feb, 10 2004 Date: Jan, 03 2006 Date: Feb, 10 2004