Export (0) Print
Expand All

DATEVALUE Function

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Converts a date in the form of text to a date in datetime format.

DATEVALUE(date_text)

Term

Definition

date_text

Text that represents a date.

A date in datetime format.

The DATEVALUE function uses the locale and date/time settings of the client computer to understand the text value when performing the conversion. If the current date/time settings represent dates in the format of Month/Day/Year, then the string, "1/8/2009", would be converted to a datetime value equivalent to January 8th of 2009. However, if the current date and time settings represent dates in the format of Day/Month/Year, the same string would be converted as a datetime value equivalent to August 1st of 2009.

If the year portion of the date_text argument is omitted, the DATEVALUE function uses the current year from your computer's built-in clock. Time information in the date_text argument is ignored.

The following example returns a different datetime value depending on your computer's locale and settings for how dates and times are presented.

  • In date/time settings where the day precedes the month, the example returns a datetime value corresponding to January 8th of 2009.

  • In date/time settings where the month precedes the day, the example returns a datetime value corresponding to August 1st of 2009.

=DATEVALUE("8/1/2009")
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft