繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > javascript asp教程 日期相关
- ASP
- ASP视频教程:后台页面加入限制访问和禁用缓存功能
- ASP视频教程:制作网站前台首页
- ASP视频教程:备份和还原SQL Server 2000数据库
- ASP实例教程:asp无限级显示分类代码
- IIS无法启动错误的几种情况汇总
- asp Http_Referer,Server_Name和Http_Host
- ASP 调用带参数输出的COM接口
- 隐藏修改文件时间和文件属性的ASP脚本
- ASP Crazy 模版操作类(最简单的模板类、仅提供交流)
- asp 动态数组 提供Add、Insert、Remove、RemoveAt、Search等方法。
- asp 取一个数的整数 但不是四舍五入，只要有小数，就取大于这个数的整数
- asp 判断上传文件中是否存在危险代码
- asp 获取url函数小结
- ASP 调用dll及封装dll实例
- asp 实现的冒泡排序程序
- asp 自定义分段函数/求第N名成绩
- ASP 高级模板引擎实现类
- ASP 常见的连接字符串写法(access2007)
- ASP向Excel导数据(图片)终结版 ASP操作Excel
- ASP实现防止网站被采集代码
ASP 中的 javascript asp教程 日期相关
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 249 ::
收藏到网摘: n/a
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.
评论 (0) All
