Difference between revisions of "DateTimeToString"
Jump to navigation
Jump to search
(→Usage) |
m (Reverted edits by 176.8.90.7 (talk) to last revision by 194.84.116.138) |
||
Line 3: | Line 3: | ||
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. | The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. | ||
− | + | ==== Usage ==== | |
+ | <syntaxhighlight>DateTimeToString (DateTime)</syntaxhighlight> | ||
+ | Where: [[DateTime]] - a double-precision decimal DateTime value to be converted to a string expression | ||
+ | |||
==== Notes ==== | ==== Notes ==== | ||
The output example is in the default US regional date and time format. Date and time formats are controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows XP operating system. | The output example is in the default US regional date and time format. Date and time formats are controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows XP operating system. |
Revision as of 13:10, 13 February 2012
Returns a string expression corresponding to the specified DateTime value.
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.
Usage
DateTimeToString (DateTime)
Where: DateTime - a double-precision decimal DateTime value to be converted to a string expression
Notes
The output example is in the default US regional date and time format. Date and time formats are controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows XP operating system.
Example
DateTimeToString(39448.25000000) will return the string "1/1/2008 6:00:00 AM"