Difference between revisions of "DATEPART"

Revision as of 21:48, 8 February 2012

The DATEPART function returns a date/time value that is normalized to the start of the day, to match other date/time values on the same day.

Note:
To get a string that contains the date only, use something like this:

TEXT(MONTH(date_modified))+'/'+TEXT(DAY(date_modified))+'/'+TEXT(YEAR(date_modified)) </syntaxhighlight>

DATEPART('dString')) </syntaxhighlight>

DATEPART('04/22/2009 03:15 am') = '04/22/2009 12:00:00 AM'

DATEPART(DATE ('2009', '04', '22', '03', '15', '00')) = '04/22/2009 12:00:00 AM' </syntaxhighlight>

@@ Line 1: / Line 1: @@
-The DATEPART function returns a date/time value that is normalized to the start of the day, for use in comparisons with other date/time values.
+The DATEPART function returns a date/time value that is normalized to the start of the day, to match other date/time values on the same day.
-To get a string that contains the date only, use something like this:
+:'''Note:'''<br> To get a string that contains the date only, use something like this:
 :<syntaxhighlight lang="java" enclose="div">
 TEXT(MONTH(date_modified))+'/'+TEXT(DAY(date_modified))+'/'+TEXT(YEAR(date_modified))
@@ Line 15: / Line 15: @@
 ;Examples:
 :<syntaxhighlight lang="java" enclose="div">
-DATEPART('04/22/2009 03:15 am') ='04/22/2009 12:00:00 AM'
+DATEPART('04/22/2009 03:15 am') = '04/22/2009 12:00:00 AM'
-DATEPART(DATE ('2009', '04', '22', '03', '15',  '00')) ='04/22/2009 12:00:00 AM'
+DATEPART(DATE ('2009', '04', '22', '03', '15',  '00')) = '04/22/2009 12:00:00 AM'
 </syntaxhighlight>
 <noinclude>