Difference between revisions of "Manuals/calci/DATESTRING"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''DATESTRING (String)'''</div><br/> *<math>String</math> is any date value. ==Description== *This function takes a date string and returns the d...") |
|||
Line 8: | Line 8: | ||
*For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time). | *For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time). | ||
*Here It understands the continental Indian time zone abbreviations, but for general use, use a time zone offset. | *Here It understands the continental Indian time zone abbreviations, but for general use, use a time zone offset. | ||
+ | *We can use Range values also. For Example: DATESTRING(#2/3/1998-4/7/1999). | ||
+ | * #date notation needs mm/dd/yy format. | ||
==Examples== | ==Examples== |
Revision as of 14:04, 15 May 2018
DATESTRING (String)
- is any date value.
Description
- This function takes a date string and returns the date with month and day name.
- In , is the any date value.
- This function is useful for setting date values based on string values.
- For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time).
- Here It understands the continental Indian time zone abbreviations, but for general use, use a time zone offset.
- We can use Range values also. For Example: DATESTRING(#2/3/1998-4/7/1999).
- #date notation needs mm/dd/yy format.
Examples
- DATESTRING("2/3/1998") = Tue Feb 03 1998 00:00:00 GMT+0530 (India Standard Time)
- DATESTRING("10/2/2019") = Wed Oct 02 2019 00:00:00 GMT+0530 (India Standard Time)
- DATESTRING("5/4/2100") = Tue May 04 2100 00:00:00 GMT+0530 (India Standard Time)
See Also
References