When working with dates and times it is often necessary to know the current date and/or time and these values can be extracted from the server's system clock through the properties shown in the table below.
These properties are used in several of the time and date functions described below.
A D V E R T I S E M E N T
Property
Value
DateString
Returns a String value representing the current date.
DateString = 12-21-2006
Now
Returns a Date value containing the current date and time.
Now = 12/21/2006 5:20:00 AM
TimeOfDay
Returns a Date value containing the current time of day (the date is
set to 1/1/0001).
TimeOfDay = 1/1/0001 5:20:00 AM
Timer
Returns a Double value representing the number of seconds elapsed
since midnight.
Timer = 19200.1183166
TimeString
Returns a String value representing the current time of day.
TimeString = 05:20:00
Today
Returns or sets a Date value containing the current date.
Today = 12/21/2006 12:00:00 AM
Date Functions
In the following table,date functions are summarized with functions described more fully below.
Function
Use
DateAdd()
Returns a Date value containing a date and time value to which a
specified time interval has been added.
DateDiff()
Returns a Long value specifying the number of time intervals between
two Date values.
DatePart()
Returns an Integer value containing the specified component of a
given Date value.
DateSerial()
Returns a Date value representing a specified year, month, and day,
with the time information set to midnight (00:00:00).
DateValue()
Returns a Date value containing the date information represented by
a string, with the time information set to midnight (00:00:00).
Day()
Returns an Integer value from 1 through 31 representing the day of
the month.
IsDate()
Returns a Boolean value indicating whether an expression can be
converted to a date.
Month()
Returns an Integer value from 1 through 12 representing the month of
the year.
MonthName()
Returns a String value containing the name of the specified month.
WeekDay()
Returns an Integer value containing a number representing the day of
the week.
Time Functions
Time functions are summarized in the following table with functions described more fully below and several of the date functions can be applied to time measurements.
Function
Use
DateAdd()
Returns a Date value containing a date and time value to which a
specified time interval has been added.
DateDiff()
Returns a Long value specifying the number of time intervals between
two Date values.
DatePart()
Returns an Integer value containing the specified component of a
given Date value.
Hour()
Returns an Integer value from 0 through 23 representing the hour of
the day.
Minute()
Returns an Integer value from 0 through 59 representing the minute
of the hour.
Second()
Returns an Integer value from 0 through 59 representing the second
of the minute.
TimeSerial()
Returns a Date value representing a specified hour, minute, and
second, with the date information set relative to January 1 of the year
1.
TimeValue()
Returns a Date value containing the time information represented by
a string, with the date information set to January 1 of the year 1.
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
Keywords:
Date and Time Functions in VB.NET,
sql server functions,
vb net functions,
visual basic functions,
sql server date,
vb net date,
ms sql date,
oracle functions,
perl functions,
php functions,
javascript functions,
asp functions,
sql functions,
php date,
perl date,
mysql functions,
utc time,
current time
