https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103576&feed=atom&action=history
Microsoft KB Archive/103576 - Revision history
2024-03-29T10:30:59Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103576&diff=262599&oldid=prev
X010: Text replacement - """ to """
2020-07-20T08:34:02Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:34, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l92">Line 92:</td>
<td colspan="2" class="diff-lineno">Line 92:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> integer value ranging from 0-59. </pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> integer value ranging from 0-59. </pre></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Following is an example of how the NOW() function could be used from within FoxPro to return the current date and time into the cursor named output. This example assumes that a valid connection to an ODBC data source has already been established and that the connection handle is contained in the variable mhand.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Following is an example of how the NOW() function could be used from within FoxPro to return the current date and time into the cursor named output. This example assumes that a valid connection to an ODBC data source has already been established and that the connection handle is contained in the variable mhand.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><pre class="CODESAMP"> result=DBEXEC(mhand, <del style="font-weight: bold; text-decoration: none;">&quot;</del>SELECT {fn NOW()}<del style="font-weight: bold; text-decoration: none;">&quot;</del>,<del style="font-weight: bold; text-decoration: none;">&quot;</del>output<del style="font-weight: bold; text-decoration: none;">&quot;</del>) </pre></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre class="CODESAMP"> result=DBEXEC(mhand, <ins style="font-weight: bold; text-decoration: none;">"</ins>SELECT {fn NOW()}<ins style="font-weight: bold; text-decoration: none;">"</ins>,<ins style="font-weight: bold; text-decoration: none;">"</ins>output<ins style="font-weight: bold; text-decoration: none;">"</ins>) </pre></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In Visual FoxPro, use the following syntax</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In Visual FoxPro, use the following syntax</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><pre class="CODESAMP"> result=SQLEXEC(mhand, <del style="font-weight: bold; text-decoration: none;">&quot;</del>SELECT {fn NOW()}<del style="font-weight: bold; text-decoration: none;">&quot;</del>,<del style="font-weight: bold; text-decoration: none;">&quot;</del>output<del style="font-weight: bold; text-decoration: none;">&quot;</del>) </pre></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre class="CODESAMP"> result=SQLEXEC(mhand, <ins style="font-weight: bold; text-decoration: none;">"</ins>SELECT {fn NOW()}<ins style="font-weight: bold; text-decoration: none;">"</ins>,<ins style="font-weight: bold; text-decoration: none;">"</ins>output<ins style="font-weight: bold; text-decoration: none;">"</ins>) </pre></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== REFERENCES ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== REFERENCES ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Microsoft Open Database Connectivity Software Development Kit (SDK) <del style="font-weight: bold; text-decoration: none;">&quot;</del>Programmer's Reference,<del style="font-weight: bold; text-decoration: none;">&quot; </del>version 1.0, pages 527-528</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Microsoft Open Database Connectivity Software Development Kit (SDK) <ins style="font-weight: bold; text-decoration: none;">"</ins>Programmer's Reference,<ins style="font-weight: bold; text-decoration: none;">" </ins>version 1.0, pages 527-528</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Additional query words: VFoxWin FoxWin FoxDos CK 2.50 2.50a</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Additional query words: VFoxWin FoxWin FoxDos CK 2.50 2.50a</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/103576&diff=47821&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:03:18Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base Articles<br />
| <br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="Q103576"></span>SQL Server Time/Date Func Support for Connectivity Kit =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="bottom"><br />
<br />
Q103576<br />
<br />
<br />
-----<br />
<br />
The information in this article applies to:<br /><br />
<br />
* Microsoft Visual FoxPro for Windows, version 3.0<br />
* Microsoft FoxPro Connectivity Kit for Windows, version 2.5, 2.5a<br />
* Microsoft FoxPro Connectivity Kit for MS-DOS, version 2.5, 2.5a<br />
<br />
<br />
-----<br />
<br />
<br /><br />
<br />
== SUMMARY ==<br />
<br />
The Microsoft FoxPro Connectivity Kit can be used with FoxPro versions 2.5 and 2.5a for MS-DOS and Windows. The FoxPro Connectivity Kit, and the Open Database Connectivity (ODBC) specification in general, supports the minimum ANSI SQL standard. Below is a list of the SQL date and time functions that are supported.<br />
<br />
<br /><br />
<br />
== MORE INFORMATION ==<br />
<br />
The following table lists the supported date and time functions.<br /><br />
<br /><br />
Parameter arguments listed as DATE_EXP can be a date-type column name, a date literal, or a date type result from another function call.<br /><br />
<br /><br />
Parameter arguments listed as TIME_EXP can be a column name, a time literal, a timestamp, or results from another function call.<br />
<br />
<pre class="FIXEDTEXT"> Function Description<br />
------------------------------------------------------------------<br />
<br />
NOW() Returns the current date and time as a<br />
timestamp value.<br />
<br />
CURDATE() Returns the current date.<br />
<br />
DAYOFMONTH(date_exp) Returns the day of the month in DATE_EXP<br />
as an integer value ranging from 1-31.<br />
<br />
DAYOFWEEK(date_exp) Returns the day of the week in DATE_EXP<br />
as an integer value ranging from 1-7,<br />
where 1 refers to Sunday.<br />
<br />
DAYOFYEAR(date_exp) Returns the day of the year in DATE_EXP<br />
as an integer value ranging from 1-366.<br />
<br />
MONTH(date_exp) Returns the month in DATE_EXP as an<br />
integer value ranging from 1-12.<br />
<br />
QUARTER(date_exp) Returns the quarter in DATE_EXP as an<br />
integer value ranging from 1-4.<br />
<br />
WEEK(date_exp) Returns the week in DATE_EXP as an<br />
integer value ranging from 1-12.<br />
<br />
YEAR(date_exp) Returns the year in DATE_EXP as an<br />
integer value.<br />
<br />
CURTIME() Returns the current local time as a time<br />
value.<br />
<br />
HOUR(time_exp) Returns the hour in TIME_EXP as an<br />
integer value ranging from 0-23.<br />
<br />
MINUTE(time_exp) Returns the minute in TIME_EXP as an<br />
integer value ranging from 0-59.<br />
<br />
SECOND(time_exp) Returns the second in TIME_EXP as an<br />
integer value ranging from 0-59. </pre><br />
Following is an example of how the NOW() function could be used from within FoxPro to return the current date and time into the cursor named output. This example assumes that a valid connection to an ODBC data source has already been established and that the connection handle is contained in the variable mhand.<br />
<pre class="CODESAMP"> result=DBEXEC(mhand, &quot;SELECT {fn NOW()}&quot;,&quot;output&quot;) </pre><br />
In Visual FoxPro, use the following syntax<br />
<pre class="CODESAMP"> result=SQLEXEC(mhand, &quot;SELECT {fn NOW()}&quot;,&quot;output&quot;) </pre><br />
<br /><br />
<br />
== REFERENCES ==<br />
<br />
Microsoft Open Database Connectivity Software Development Kit (SDK) &quot;Programmer's Reference,&quot; version 1.0, pages 527-528<br />
<br />
Additional query words: VFoxWin FoxWin FoxDos CK 2.50 2.50a<br />
<br />
Keywords :<br /><br />
Issue type :<br /><br />
Technology : kbVFPsearch kbAudDeveloper kbVFP300<br />
<br />
<br /><br />
Last Reviewed: August 25, 1999<br /><br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:MSDN@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
© 2002 Microsoft Corporation. All rights reserved.<br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd