 |
 |
|
Date e Time Properties
|
|
Nel funzionare con le date ed i periodi � necessario spesso da conoscere la data corrente e/o da cronometrare e questi valori possono essere estratti dall'orologio del sistema dell'assistente attraverso le propriet� indicate nella tabella qui sotto. Queste propriet� sono usate in varie delle funzioni della data e di tempo descritte qui sotto.
|
| 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
|
|
Nella seguente tabella, le funzioni della data sono ricapitolate con le funzioni hanno descritto pi� completamente qui sotto.
|
| 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
|
|
Le funzioni di tempo sono ricapitolate nella seguente tabella con le funzioni hanno descritto pi� completamente qui sotto e varie delle funzioni della data possono essere applicate alle misure di tempo.
|
| 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. |
|
|
|
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
|
