Untuk tanggal yang disimpan dalam bidang jenis tanggal dan waktu dari database Access, efek membaca data langsung dari database sangat memakan waktu. Editor saluran teknologi baru akan memberi tahu Anda secara rinci tentang format fungsi pemformatan tanggal yang umum digunakan dari ASP.
Kode inti
Fungsi <%': Fungsi pemformatan tanggal multifungsi'source: http://jorkin.reallydo.com/article.asp?id=477Function formatDate (sdatetime, sreallydo) sdatime) sdatime = getLocale () jika tidak isdate (sdatime) kemudian sdatime = getLocale () if not isdate (sdatime) kemudian sdatime) sdatime = getLocale () if not isdate (sdatime) kemudian sdatime) sdatime = sdatime = sdatime (sdateMeMe) sdateMeIME (sdateTime) sdatime (sdateTime) (sdateTime) kemudian SDATIMEMETIME = SDATIME (sdateTime) SDATIME (SDATETIME (SDATIME) Case UCase(sReallyDo & "") Case "0", "1", "2", "3", "4" FormatDate = FormatDateTime(sDateTime, sReallyDo) Case "00" FormatDate = FormatDate(sDateTime, "YYYY-MM-DD hh:mm:ss") Case "01" FormatDate = FormatDate(sDateTime, Yyyyyyy mm bulan tanggal dd ") case" 02 "formatDate = formatDate (sDateTime," yyyy-mm-dd ") case" 03 "formatDate = formatDate (sDateTime," hh: mm: ss ") case" 04 "formatdate = formatdate (" sse: "format hh:" ss ") 04" formatdate = formate ("sse:" formatdate = formatdate ("sse:" formatdate = formatdate ("sse:" format hh: "ss" hy: "format hh: ss") 04 "formatdate = format hh: ss") 04 " "Iso8601", "google", "sitemap" '// format iso8601, umumnya digunakan untuk googlesitemap, "+08: 00" adalah zona waktu. FormatDate = formatDate (sDateTime, "yyyy-mm-ddthh: mm: ss. 000+08: 00") kasus "rfc822", "rss", "feed" '// format RFC822, umumnya digunakan untuk RSS, "+0800" adalah zona waktu. Setlocale ("en-gb") formatDate = formatDate (sDateTime, "ew, dd emm yyyy hh: mm: ss +0800") setLocale (sjorkin) case "rnd", "rand", "randomisasi" // FORCATEZEIZE PRINTATIZED SJORKIN, RND = RND () RACKATED () FORCATECETEIZED () FORCATEZEIZED SJORKIN SJORKIN = RND = RND () RACEPATED () Sl REACKATECED () READECATEREZED SJORKIN () READECATEZED (), RECATECATEZEIZED SJORKIN (), RECATECATEZED SJORKIN (), RECATECATEZED () "Yyymmddhhmmss") & _ fix ((9 * 10^6 -1) * sjorkin) + 10^6 case else formatDate = sRealllydo formatDate = ganti (formatDate, "yyyy", tahun (sdateTime)) format 2 (format "," format "," format "," format "," format "," sdateTime "," sdateTime "," sdateTime ("sdateTime (format" Ganti (formatDate, "hh", kanan ("0" & jam (sDateTime), 2)) formatDate = ganti (formatDate, "mm", kanan ("0" & menit (sDateTime), 2), "format ganti (format) (format 2), kanan (" 0 "& kedua (sdateTime) (sdateTime) (sdateTime) (sdateTime) (sdateTime) (sdateTime, Right(Year(sDateTime), 2)) FormatDate = Replace(FormatDate, "D", Day(sDateTime)) FormatDate = Replace(FormatDate, "h", Hour(sDateTime)) FormatDate = Replace(FormatDate, "m", Minute(sDateTime)) FormatDate = Replace(FormatDate, "s", Second(sDateTime)) If InStr(1, FormatDate, "EW", 1) > 0 Then SetLocale("en-gb") FormatDate = Replace(FormatDate, "EW", UCase(WeekdayName(Weekday(sDateTime), False))) FormatDate = Replace(FormatDate, "eW", WeekdayName(Weekday(sDateTime), False)) FormatDate = Replace(FormatDate, "Ew", UCase(WeekdayName(Weekday(sDateTime), True))) FormatDate = Replace(FormatDate, "ew", WeekdayName(Weekday(sDateTime), True)) SetLocale(sJorkin) Else FormatDate = Replace(FormatDate, "W", WeekdayName(Weekday(sDateTime), False)) FormatDate = Ganti (formatDate, "w", WeekdayName (hari kerja (sDateTime), true)) berakhir jika jika instr instr (1, formatDate, "emm", 1)> 0 lalu setlocale ("en-gb") format = ganti (formatdate, "eMM", monthname (bulan (bulan (sdatetime), false))), format "format", bulan (bulan), format), format "format", format "format" format "format" format "format" format "format" format "format" format "format" format "format" format "format" format "format" format "format" BulanName (bulan (sDateTime), true)) setLocale (sjorkin) else formatDate = ganti (formatDate, "mm", kanan ("0" & bulan (sDateTime), 2)) formatdate = ganti (format, "m", bulan (sDatetime)) akhir fungsi akhir>Penggunaannya adalah sebagai berikut:
<%'Tanggal Format ke ISO8601 Format Response.Write (formatDate ("2008-03-06 08:03:06", "Sitemap"))' Tanggal Format untuk RFC822 Format Response.write (formatDate ("2008-03-06 08:03:03", "rss," reds) ("2008-06 08:03:03", "rss"), rss ") (Day Date 08 08 08:03:06," RS, "RS," RS ") (" Tahun) response.write (formatDate (sekarang (), "ew, emm/dd/yyyy")) 'menghasilkan serangkaian angka acak dalam tahun, bulan, hari, jam, menit, dan respons detik.Di atas adalah editor saluran teknologi baru yang salah. Konten tentang format fungsi pemformatan tanggal yang umum digunakan dari ASP. Jika ada yang tertarik dengan industri ini, ia dapat memberikan pelatihan dalam hal ini.