|
Data e propriedades de Tempo
|
|
Ao trabalhar com datas e épocas é frequentemente necessário saber a data atual e/ou a cronometrar e estes valores podem ser extraídos do pulso de disparo do sistema do usuário através das propriedades mostradas na tabela abaixo. Estas propriedades são usadas em diversas das funções da hora e da data descritas abaixo.
|
| 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 |
|
|
Funções da data
|
|
Na seguinte tabela, as funções da data são sumariadas com funções descreveram mais inteiramente abaixo. .
|
| 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. |
|
|
Funções de tempo
|
|
As funções de tempo são sumariadas na seguinte tabela com funções descreveram mais inteiramente abaixo e diversas das funções da data podem ser aplicadas às medidas do 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
|
