https://panoptic.com/mediawiki/aolserver/index.php?action=history&feed=atom&title=Ns_buildsqldate 2026-04-08T07:10:34Z Revision history for this page on the wiki MediaWiki 1.34.2 https://panoptic.com/mediawiki/aolserver/index.php?title=Ns_buildsqldate&diff=5314&oldid=prev 2009-02-07T20:04:11Z

<p></p> <table class="diff diff-contentalign-left" 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"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 20:04, 7 February 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l31" >Line 31:</td> <td colspan="2" class="diff-lineno">Line 31:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>: [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>: [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; 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><del class="diffchange diffchange-inline">----</del></div></td><td class='diff-marker'>+</td><td style="color: #222; 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>[[Category<ins class="diffchange diffchange-inline">:</ins>Documentation]] [[Category<ins class="diffchange diffchange-inline">:</ins>Core Tcl API]]</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; 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> </div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; 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>[[Category Documentation]] <del class="diffchange diffchange-inline">- </del>[[Category Core Tcl API]]</div></td><td colspan="2"> </td></tr> </table>

Gustafn https://panoptic.com/mediawiki/aolserver/index.php?title=Ns_buildsqldate&diff=2766&oldid=prev 2004-07-28T06:23:04Z

<p>imported from WiKit id 524</p> <p><b>New page</b></p><div>Man page: http://aolserver.com/docs/tcl/ns_buildsqldate.html<br /> <br /> ----<br /> <br /> '''NAME'''<br /> <br /> : ns_buildsqldate - Build a SQL date value from specified month, day, and year<br /> <br /> '''SYNOPSIS'''<br /> <br /> : '''ns_buildsqldate''' ''month day year''<br /> <br /> '''DESCRIPTION'''<br /> <br /> : This command builds a SQL date string out of the specified month, day, and year. The month can be the month number (1 - 12) or the full, capitalized month name (January, February, ..., December). The day must be a number from 1 - 31, and the year must be a 4-digit year (e.g., 1957). An error is returned if any of the argument values are invalid. The resulting string can be used in an SQL statement.<br /> <br /> '''EXAMPLES'''<br /> <br /> % ns_buildsqldate &quot;01&quot; &quot;15&quot; &quot;1929&quot;<br /> 1929-01-15<br /> <br /> % ns_buildsqldate &quot;13&quot; &quot;31&quot; &quot;2000&quot;<br /> Invalid date: 13 31 2000<br /> while executing ...<br /> <br /> % set thedate [[ns_buildsqldate &quot;January&quot; &quot;15&quot; &quot;1929&quot;]]<br /> % ns_db dml $db &quot;INSERT INTO mytable (datefield) VALUES ([[ns_dbquotevalue $thedate]])&quot;<br /> <br /> '''SEE ALSO'''<br /> <br /> : [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]]<br /> <br /> ----<br /> <br /> [[Category Documentation]] - [[Category Core Tcl API]]</div>

WikiSysop