Export (0) Print
Expand All

DateAndTime Methods

The DateAndTime type exposes the following members.

  Name Description
Public method Static member DateAdd(DateInterval, Double, DateTime) Returns a Date value containing a date and time value to which a specified time interval has been added.
Public method Static member DateAdd(String, Double, Object) Returns a Date value containing a date and time value to which a specified time interval has been added.
Public method Static member DateDiff(DateInterval, DateTime, DateTime, FirstDayOfWeek, FirstWeekOfYear) Returns a Long value specifying the number of time intervals between two Date values.
Public method Static member DateDiff(String, Object, Object, FirstDayOfWeek, FirstWeekOfYear) Returns a Long value specifying the number of time intervals between two Date values.
Public method Static member DatePart(DateInterval, DateTime, FirstDayOfWeek, FirstWeekOfYear) Returns an Integer value containing the specified component of a given Date value.
Public method Static member DatePart(String, Object, FirstDayOfWeek, FirstWeekOfYear) Returns an Integer value containing the specified component of a given Date value.
Public method Static member DateSerial Returns a Date value representing a specified year, month, and day, with the time information set to midnight (00:00:00).
Public method Static member DateValue Returns a Date value containing the date information represented by a string, with the time information set to midnight (00:00:00).
Public method Static member Day Returns an Integer value from 1 through 31 representing the day of the month.
Public method Equals(Object) Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Public method Static member Hour Returns an Integer value from 0 through 23 representing the hour of the day.
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method Static member Minute Returns an Integer value from 0 through 59 representing the minute of the hour.
Public method Static member Month Returns an Integer value from 1 through 12 representing the month of the year.
Public method Static member MonthName Returns a String value containing the name of the specified month.
Public method Static member Second Returns an Integer value from 0 through 59 representing the second of the minute.
Public method Static member 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.
Public method Static member 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.
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Public method Static member Weekday Returns an Integer value containing a number representing the day of the week.
Public method Static member WeekdayName Returns a String value containing the name of the specified weekday.
Public method Static member Year Returns an Integer value from 1 through 9999 representing the year.
Top

Community Additions

ADD
Show:
© 2014 Microsoft