MSSQL:
小时:select SubString(convert(varchar(20),getdate(),120),12,2) as HH
分钟:select SubString(convert(varchar(20),getdate(),120),15,2) as MM
select SubString(convert(varchar(20),getdate(),120),12,8) as datetime
datetime
----------------
23:23:34
set @currentDatetime=getdate()
set @year=DATENAME(Year,@currentDatetime)
set @month=DATENAME(Month,@currentDatetime)
set @day=DATENAME(Day,@currentDatetime)
set @hour=DATENAME(Hour,@currentDatetime)
set @min=DATENAME(Minute,@currentDatetime)
set @Sec=DATENAME(Second,@currentDatetime)
set @Millisecond=DATENAME(Millisecond,@currentDatetime)
RETURN