codice:
function formatDBDate(argDate,argDB)
dim tmpdate,tmpdateoutput
tmpdate = argDate
select case argDB
case "mdb"
tmpdateoutput = "#yyyy-mm-dd h:m:s#"
case "mysql"
tmpdateoutput = "'yyyy-mm-dd'"
end select
tmpdateoutput = replace(tmpdateoutput,"dd",right("0" & day(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"mm",right("0" & month(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"yyyy",year(tmpdate))
tmpdateoutput = replace(tmpdateoutput,"yy",right(year(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"h",right("0" & hour(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"m",right("0" & minute(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"s",right("0" & second(tmpdate),2))
formatDBDate = tmpdateoutput
end function
function getGMTDate(argDate,argGMT)
getGMTDate = dateadd("h",argGMT,argDate)
end function
function formatGMTDate(argDate, argGMT, argFormat)
dim tmpdate,tmpdateoutput
tmpdate = getGMTDate(argDate,argGMT)
tmpdateoutput = argFormat
tmpdateoutput = replace(tmpdateoutput,"dd",right("0" & day(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"mm",right("0" & month(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"yyyy",year(tmpdate))
tmpdateoutput = replace(tmpdateoutput,"yy",right(year(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"h",right("0" & hour(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"m",right("0" & minute(tmpdate),2))
tmpdateoutput = replace(tmpdateoutput,"s",right("0" & second(tmpdate),2))
formatGMTDate = tmpdateoutput
end function
data_comp = request.form("data_comp")
data_compilazione = formatDBDate(data_comp, "mysql")
nr = request.form("nr")
id = request.form("id")
<image src='http://miosito.it/img/apri_button.gif' border='0'>