各式取日期方法YYYYMMDD

ASP
function sNowDate()
sNowDateY=year(now)
sNowDateM=month(now)
if sNowDateM < 10 then sNowDateM="0" & sNowDateM
sNowDateD=Day(now)
if sNowDateD < 10 then sNowDateD="0" & sNowDateD
sNowDateHH=hour(now)
if sNowDateHH < 10 then sNowDateHH="0" & sNowDateHH
sNowDateMM=minute(now)
if sNowDateMM < 10 then sNowDateMM="0" & sNowDateMM
sNowDateSS=second(now)
if sNowDateSS < 10 then sNowDateSS="0" & sNowDateSS
sNowDate=sNowDateY & sNowDateM & sNowDateD & sNowDateHH & sNowDateMM & sNowDateSS
end function
C#
DateTime.Now.ToString("yyyyMMdd")
忽略系統時間格式設置DateTime.Now.ToString("yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo);

SQL
--8碼===========
set @dDate=(select CONVERT(char(8),getdate(), 112 ))
--14碼==========
set @dDate=(select CONVERT(char(8),getdate(), 112 )+CONVERT(char(6),replace(CONVERT(char(8),getdate(), 114 ),':','')) )
--14碼時間差=========
declare @dDate varchar(14)set @dDate=CONVERT(char(8),dateadd(hour,-1,getdate()), 112 ) + replace(CONVERT(char(14),dateadd(hour,-1,getdate()), 114 ),':','')select @dDate