繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > javascript asp教程 日期相关
- ASP
- 网络寻呼机数据库版删除选中的消息deletemessage.asp
- 网络寻呼机数据库版隐藏文件watch.asp
- 网络寻呼机数据库版总结
- 一种在线人数统计方法（只用1个APPLICATION）
- 用ASP.NET构建完整E-mail发送系统
- 用ASP.NET建立简单的Web Form
- 为你的ASP程序制作一个编译组件（上）
- 为你的ASP程序制作一个编译组件（中）
- 为你的ASP程序制作一个编译组件（下）
- 利用ASP将HTML格式数据传输给Excel（1）
- 利用ASP将HTML格式数据传输给Excel（2）
- 利用ASP将HTML格式数据传输给Excel（3）
- 利用ASP将HTML格式数据传输给Excel（4）
- 磁盘ID在ASP源码防拷贝中的应用
- WEB环境下打印报表的crystal的解决方案
- 如何把存储在数据库中的图片根据自己的需要的大小显示出来
- 客户端用ASP+rds+VBA参生报表
- 利用ASP.NET设计FTP文件上传(上)
- 利用ASP.NET设计FTP文件上传(中)
- 利用ASP.NET设计FTP文件上传(下)
ASP 中的 javascript asp教程 日期相关
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 101 ::
收藏到网摘: 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
