javascript asp教程の日付は関連しています。
4163 ワード
JavaScript is loosely typed.Database files are not.If you put text into a Boolean database column or a Boolean value into a date/time column，then you will get an error.
For the most part this is not a problem，except for date/time.It does not coreress pond to the JavaScript Date Object.So，we have to tear Date atd and rebuild it from scratch.If we don't，the migeat.smat。
Take a look at the snippet below.(It's not part of our lesson，but I want you to look at it anyway.)Please notice DateTime.
Get Startd:
Below is the script for Lesson 20.
Living on VBIScript Time:
The other way to solive the problem is to use the VB Script date and time Object.What can I say？If you can't beat'em、steal from'em！
Time For a Tangent:
If a ll You want to is store new Date()exactly as-in your database then do so in a text or memo column.The disadge of using this tactic is that SQL cannot sort items corectly by and the able.Inders.Inders.ine.inders.Inter。
That's the end of the lesson plan.I have received message from all over the world.Thank you for your kind words.If you have questions or comments you can click onto the link for the home pame and the n the the the e's lintwork to.intwork。
For the most part this is not a problem，except for date/time.It does not coreress pond to the JavaScript Date Object.So，we have to tear Date atd and rebuild it from scratch.If we don't，the migeat.smat。
Take a look at the snippet below.(It's not part of our lesson，but I want you to look at it anyway.)Please notice DateTime.
objConn.Open(strConnect)
sql = "INSERT INTO FoloVisit (SessionID,VisitTime) "
sql+= "Values ('" + Session.SessionID + "',#" + DateTime + "#);"
objConn.Execute(sql)
Get Startd:
Below is the script for Lesson 20.
<%@LANGUAGE="JavaScript"%>
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
Dim VBTime,VBDate,VBDateTime
VBTime = Time & " "
VBDate = Date & " "
VBDateTime = Date & " " & Time
</SCRIPT>
<%
function whatTimeIsIt()
{
var m=new Date()
var minute=m.getMinutes()
var second=m.getSeconds()
var ampm=false
if (minute >=0 && minute < 10)
{ minute=("0" + minute) }
if (second >= 0 && second < 10 )
{ second=("0" + second) }
var hours=m.getHours()
if (hours > 12)
{ ampm=true
hours=hours-12 }
if (hours==12)
{ ampm=true }
if (hours == 0)
{ hours=hours+12
ampm=false }
if (ampm)
{ ampm=" PM" }
else
{ ampm=" AM" }
var myTime=hours + ":" + minute + ":" + second + ampm
return myTime;
}
var DateTime = new Date();
var Month = (DateTime.getMonth() + 1) + "/";
var Day = DateTime.getDate() + "/";
var Year = DateTime.getFullYear();
var JustTheDate = Month + Day + Year;
var JustTheTime = whatTimeIsIt();
var DateTime = Month + Day + Year + " " + whatTimeIsIt();
Response.Write("<HTML>\r")
Response.Write("<STRONG>JavaScript Time</STRONG><BR>\r")
Response.Write("The date in proper database format is: " + JustTheDate + "<BR>\r")
Response.Write("The time in proper database format is: " + JustTheTime + "<BR>\r")
Response.Write("The date & time together are: " + DateTime + "<BR>\r")
Response.Write("<HR>\r")
Response.Write("<STRONG>VBScript Time</STRONG><BR>\r")
Response.Write("The date in proper database format is: " + VBDate + "<BR>\r")
Response.Write("The time in proper database format is: " + VBTime + "<BR>\r")
Response.Write("The date & time together are: " + VBDateTime + "<BR>\r")
Response.Write("</HTML>")
%>
Living on VBIScript Time:
The other way to solive the problem is to use the VB Script date and time Object.What can I say？If you can't beat'em、steal from'em！
Time For a Tangent:
If a ll You want to is store new Date()exactly as-in your database then do so in a text or memo column.The disadge of using this tactic is that SQL cannot sort items corectly by and the able.Inders.Inders.ine.inders.Inter。
That's the end of the lesson plan.I have received message from all over the world.Thank you for your kind words.If you have questions or comments you can click onto the link for the home pame and the n the the the e's lintwork to.intwork。