/**
popular collection of scripts for all
*/
/** Search */
{
Date and Time
}|
With DatePart() function in
In this tutorial we will
This function is very useful,
This tutorial will show you
VBScript language you could
compare dates. We will use
if you wish to get date of
how to display the current
take only some parts of
DateDiff function. You may
current SQL server date and
date with the ordinal suffix
current time and display/use
compare any two valid dates
time. You may use this
e.g. Wednesday 12th May
in your applications.
calculation year, day,
function to fill some rows
Following examples will show
month, week, minute ans
automatically with current
you and give a brief on this
seconds.
time or using with DateDiff
function. .
function to return the
number between current time.
Date: Sep, 15 2006 Date: Mar, 02 2006 Date: Feb, 10 2004 Date: Mar, 07 2005 |
|
When inserting a date into an
DatePart function is a very
This is an useful but not
Following example displays
Access database you should
useful function to get the a
known functions. If you wish
usage of setDate method in
use the format YYYY-MM-DD.
part of a date. You may get
to learn month of date
JScript. 'setDate methods
Our function AccessDate
year, month, day of year ..
stored in a database, you
sets the numeric date of the
returns a date in YYYY-MM-DD
etc. of a specific date.
may use this function
Date object using local time.
format.
When working with a
placing in a 'SELECT' sql
date in Access always use
statement
the # delimiters in your SQL
statement.
Date: Dec, 13 2005 Date: Apr, 12 2004 Date: Feb, 10 2004 Date: Apr, 20 2004 |
{ Copyright } ©2019 NuclearScripts.com