 |
 |
|
Date and Time Properties
|
|
Beim Arbeiten mit Daten und Zeiten Zeit festzusetzen Zeit festzusetzen h�ufig ist notwendig, das Tagesdatum zu kennen und/oder und diese Werte k�nnen vom Taktgeber System des Bedieners durch die Eigenschaften extrahiert werden, die unten in der Tabelle gezeigt werden. Diese Eigenschaften werden in mehreren der unten beschriebenen Zeit- und Datumfunktionen benutzt.
|
| 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 der folgenden Tabelle werden Date Functions mit Funktionen beschrieben v�llig unten zusammengefa�t.
|
| 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 werden in der folgenden Tabelle mit Funktionen beschrieben v�llig unten zusammengefa�t und mehrere der Datumfunktionen k�nnen an den Zeitma�en angewendet werden.
|
| 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
|
