UC知道关于now() 问题
来源：百度知道 编辑：UC知道 时间：2024/05/28 14:46:33
dingdan=now()
dingdan=replace(trim(dingdan),"-","")
dingdan=replace(dingdan,":","")
dingdan=replace(dingdan," ","")
是ASP+ACCESS ,如果是英文的操作系统上面时间now()写入数据库后是：2009/3/25155912
这咱格式，中文操作系统2009325155912，这咱格式，现在是想让它固定2009325155912这种格式，不要有/
dingdan=replace(trim(dingdan),"-","")
dingdan=replace(dingdan,":","")
dingdan=replace(dingdan," ","")
是ASP+ACCESS ,如果是英文的操作系统上面时间now()写入数据库后是：2009/3/25155912
这咱格式，中文操作系统2009325155912，这咱格式，现在是想让它固定2009325155912这种格式，不要有/
那就把/也替换了吧：
dingdan=now()
dingdan=replace(trim(dingdan),"/","")
dingdan=replace(trim(dingdan),"-","")
dingdan=replace(dingdan,":","")
dingdan=replace(dingdan," ","")
vb 中有Format函数可以固定输入格式：dingdan=format（now,"yyyymmddhhmmss")，然后再写入数据库，ASP你可参考下FormatDateTime 函数 。