javascript asp教程 日期相关
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了javascript asp教程 日期相关,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3222字,纯文字阅读大概需要5分钟。
内容图文
![javascript asp教程 日期相关](/upload/InfoBanner/zyjiaocheng/385/7081245bdc734abb92822acd527b4863.jpg)
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
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
objConn.Open(strConnect) sql = "INSERT INTO FoloVisit (SessionID,VisitTime) " sql+= "Values ('" + Session.SessionID + "',#" + DateTime + "#);" objConn.Execute(sql)
DateTime has to be in a very particular format:
Get Started:
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>") %>
Click Here to run the script in a new window.
Living on VBScript Time:
The other way to solve the problem is to use the VBScript date and time Objects. What can I say? If you can't beat 'em, steal from 'em!
Time For a Tangent:
If all you want to do is store
That's the end of the lesson plan. I have received messages 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 page and then there's a link to contact me.
内容总结
以上是互联网集市为您收集整理的javascript asp教程 日期相关全部内容,希望文章能够帮你解决javascript asp教程 日期相关所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。