/**
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
This is an useful but not
DatePart function is a very
Following example displays
Access database you should
known functions. If you wish
useful function to get the a
usage of setDate method in
use the format YYYY-MM-DD.
to learn month of date
part of a date. You may get
JScript. 'setDate methods
Our function AccessDate
stored in a database, you
year, month, day of year ..
sets the numeric date of the
returns a date in YYYY-MM-DD
may use this function
etc. of a specific date.
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: Feb, 10 2004 Date: Apr, 12 2004 Date: Apr, 20 2004 |
{ Copyright } ©2019 NuclearScripts.com