StringToDays (String function) - Revision history

ELowell at 22:11, 3 September 2015

2015-09-03T22:11:18Z

← Older revision		Revision as of 22:11, 3 September 2015
Line 1:		Line 1:
	{{Template:String:StringToDays subtitle}}		{{Template:String:StringToDays subtitle}}

	<var>StringToDays</var> is an [[Intrinsic classes\|intrinsic]] function to convert a [[Datetime_string_formats\|date/time string]] to days since 1900.		<var>StringToDays</var> is an [[Intrinsic classes\|intrinsic]] function to convert a [[Datetime_string_formats\|date/time string]] to days since 1900.

JAL at 21:15, 5 November 2012

2012-11-05T21:15:25Z

← Older revision		Revision as of 21:15, 5 November 2012
Line 5:		Line 5:
	==Syntax==		==Syntax==
	{{Template:String:StringToDays syntax}}		{{Template:String:StringToDays syntax}}

	===Syntax terms===		===Syntax terms===
	<table class="syntaxTable">		<table class="syntaxTable">
	<tr><th>%days</th>		<tr><th>%days</th>
	<td>The float variable to receive the computed time since 1900.</td></tr>		<td>The float variable to receive the computed time since 1900.</td></tr>

	<tr><th>string</th>		<tr><th>string</th>
	<td>The input date/time string, which must be in the format specified by <var class="term">format</var>.</td></tr>		<td>The input date/time string, which must be in the format specified by <var class="term">format</var>.</td></tr>

	<tr><th>format</th>		<tr><th>format</th>
	<td>The format of the date/time string. See [[Datetime string formats#Datetime Formats\|"Datetime formats"]].</td></tr>		<td>The format of the date/time string. See [[Datetime string formats#Datetime Formats\|"Datetime formats"]].</td></tr>

	<tr><th><var>CentSpan</var></th>		<tr><th><var>CentSpan</var></th>
	<td>The <var>[[Datetime string formats#CENTSPAN\|CENTSPAN]]</var> value used, if ~~the~~ <var class="term">format</var> has a two-digit year. The default is specified by the <var class="camel">[[CENTSPAN parameter\|CENTSPAN ~~parameter~~]]</var>. In <var class="product">Sirius Mods</var> 7.9 and later this is a [[Notation conventions for methods#Named parameters\|name allowed]] parameter. For versions prior to 7.9, it is a positional parameter.</td/tr>		<td>The <var>[[Datetime string formats#CENTSPAN\|CENTSPAN]]</var> value used, if <var class="term">format</var> has a two-digit year. The default is specified by the <var class="camel">[[CENTSPAN parameter\|CENTSPAN]]</var> parameter. In <var class="product">Sirius Mods</var> 7.9 and later, this is a [[Notation conventions for methods#Named parameters\|name allowed]] parameter. For versions prior to 7.9, it is a positional parameter.</td/tr>
	</table>		</table>

Line 20:		Line 24:
	<ul>		<ul>
	<li>If the <var class="term">format</var> is invalid, the request is cancelled.		<li>If the <var class="term">format</var> is invalid, the request is cancelled.

	<li>If the date contents of the method object <var class="term">string</var> is invalid, an <var>[[InvalidDateString class\|InvalidDateString]]</var> exception is thrown.		<li>If the date contents of the method object <var class="term">string</var> is invalid, an <var>[[InvalidDateString class\|InvalidDateString]]</var> exception is thrown.

	<li>If the <var>CentSpan</var> value is invalid, the request is canceled.		<li>If the <var>CentSpan</var> value is invalid, the request is canceled.

	<li>Values returned by <var>StringToDays</var> can be stored in a BINARY or FLOAT4 field, if you want.		<li>Values returned by <var>StringToDays</var> can be stored in a BINARY or FLOAT4 field, if you want.

	<li>Dates prior to 1 January 1900 return a negative number.		<li>Dates prior to 1 January 1900 return a negative number.

	<li>The inverse of this function is <var>[[DaysToString (Float function)\|DaysToString]]</var>.		<li>The inverse of this function is <var>[[DaysToString (Float function)\|DaysToString]]</var>.
	</ul>		</ul>

JALWiccan: 1 revision

2012-11-02T18:29:49Z

1 revision

← Older revision	Revision as of 18:29, 2 November 2012
(No difference)

Dme: /* See also */

2012-11-02T18:29:47Z

See also

← Older revision		Revision as of 18:29, 2 November 2012
Line 1:		Line 1:
	{{Template:String:StringToDays subtitle}}		{{Template:String:StringToDays subtitle}}

	<var>StringToDays</var> is an ~~<var>~~[[Intrinsic classes\|intrinsic]]~~</var>~~ function to convert a [[Datetime_string_formats\|date/time string]] to days since 1900.		<var>StringToDays</var> is an [[Intrinsic classes\|intrinsic]] function to convert a [[Datetime_string_formats\|date/time string]] to days since 1900.

	==Syntax==		==Syntax==

Dme: /* See also */

2012-07-12T17:34:20Z

See also

← Older revision		Revision as of 17:34, 12 July 2012
Line 45:		Line 45:
	==See also==		==See also==
	<ul>		<ul>
	<li>Related intrinsic methods:		<li>Related intrinsic methods (provide conversion from one form of date representation to another):
	<ul>		<ul>
	<li><var>[[DaysToString (Float_function)\|DaysToString]]</var>		<li><var>[[DaysToString (Float_function)\|DaysToString]]</var>

JAL2: /* See also */

2012-07-10T21:02:41Z

See also

← Older revision		Revision as of 21:02, 10 July 2012
Line 60:		Line 60:
	<li><var>[[CurrentTimeDays (System function)\|CurrentTimeDays ]]</var>		<li><var>[[CurrentTimeDays (System function)\|CurrentTimeDays ]]</var>
	<li><var>[[CurrentTimeString (System function)\|CurrentTimeString ]]</var>		<li><var>[[CurrentTimeString (System function)\|CurrentTimeString ]]</var>
			</ul>
	</ul>		</ul>

	{{Template:String:StringToDays footer}}		{{Template:String:StringToDays footer}}

JAL2: /* See also */

2012-07-10T21:00:00Z

See also

← Older revision		Revision as of 21:00, 10 July 2012
Line 44:		Line 44:

	==See also==		==See also==
			<ul>
			<li>Related intrinsic methods:
	<ul>		<ul>
	<li><var>[[DaysToString (Float_function)\|DaysToString]]</var>		<li><var>[[DaysToString (Float_function)\|DaysToString]]</var>
Line 51:		Line 53:
	<li><var>[[StringToSeconds (String_function)\|StringToSeconds]]</var>		<li><var>[[StringToSeconds (String_function)\|StringToSeconds]]</var>
	<li><var>[[TimeStringConvert (String_function)\|TimeStringConvert]]</var>		<li><var>[[TimeStringConvert (String_function)\|TimeStringConvert]]</var>
			</ul>
			<li>Related <var>System</var> methods:
			<ul>
			<li><var>[[CurrentTimeMilliseconds (System function)\|CurrentTimeMilliseconds]]</var>
			<li><var>[[CurrentTimeSeconds (System function)\|CurrentTimeSeconds]]</var>
			<li><var>[[CurrentTimeDays (System function)\|CurrentTimeDays ]]</var>
			<li><var>[[CurrentTimeString (System function)\|CurrentTimeString ]]</var>
	</ul>		</ul>

	{{Template:String:StringToDays footer}}		{{Template:String:StringToDays footer}}

JAL2: /* Examples */

2012-04-03T21:38:09Z

Examples

← Older revision		Revision as of 21:38, 3 April 2012
Line 40:		Line 40:
	The result is:		The result is:
	<p class="output">'20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')=May 20, 2011 </p>		<p class="output">'20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')=May 20, 2011 </p>



	</ol>		</ol>

JAL2: /* Examples */

2012-04-03T18:24:09Z

Examples

← Older revision		Revision as of 18:24, 3 April 2012
Line 29:		Line 29:
	==Examples==		==Examples==
	<ol>		<ol>
			<li>This statement converts a value from <code>YYYYMMDD</code> format:
			<p class="code">printText {~='20110520':stringToDays('YYYYMMDD')}</p>

			The result is:
			<p class="output">'20110520':stringToDays('YYYYMMDD')=40681 </p>

	<li>This statement uses <var>StringToDays</var> and <var>[[DaysToString (Float_function)\|DaysToString]]</var> to convert a value in <code>YYYYMMDD</code> format to the <code>Month DAY, YYYY</code> format:		<li>This statement uses <var>StringToDays</var> and <var>[[DaysToString (Float_function)\|DaysToString]]</var> to convert a value in <code>YYYYMMDD</code> format to the <code>Month DAY, YYYY</code> format:
	<p class="code">printText {~='20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')}</p>		<p class="code">printText {~='20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')}</p>
Line 35:		Line 41:
	<p class="output">'20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')=May 20, 2011 </p>		<p class="output">'20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')=May 20, 2011 </p>

	~~<li>This statement converts a value in <code>YYYYMMDD</code> format to the <code>Month DAY, YYYY</code> format:~~
	~~<p class="code">printText {~='20110520':stringToDays('YYYYMMDD')}</p>~~

	~~The result is:~~
	~~<p class="output">'20110520':stringToDays('YYYYMMDD')=40681 </p>~~

	</ol>		</ol>

JAL2: /* Examples */

2012-04-03T18:22:20Z

Examples

← Older revision		Revision as of 18:22, 3 April 2012
Line 28:		Line 28:

	==Examples==		==Examples==
	This statement uses <var>StringToDays</var> and <var>[[DaysToString (Float_function)\|DaysToString]]</var> to convert a value in <code>YYYYMMDD</code> format to the <code>Month DAY, YYYY</code> format:		<ol>
			<li>This statement uses <var>StringToDays</var> and <var>[[DaysToString (Float_function)\|DaysToString]]</var> to convert a value in <code>YYYYMMDD</code> format to the <code>Month DAY, YYYY</code> format:
	<p class="code">printText {~='20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')}</p>		<p class="code">printText {~='20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')}</p>

	The result is:		The result is:
	<p class="output">'20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')=May 20, 2011 </p>		<p class="output">'20110520':stringToDays('YYYYMMDD'):daysToString('Month DAY, YYYY')=May 20, 2011 </p>

			<li>This statement converts a value in <code>YYYYMMDD</code> format to the <code>Month DAY, YYYY</code> format:
			<p class="code">printText {~='20110520':stringToDays('YYYYMMDD')}</p>

			The result is:
			<p class="output">'20110520':stringToDays('YYYYMMDD')=40681 </p>

			</ol>

	==See also==		==See also==