那是无标准sql的规格, 肯定是五花百门. 不如给你另类的答案Interbase 6.x: Select Cast('now' as date) from rdb$database;===> '09/13/02'Select case('now' as timestamp) from rdb$database;===> '09/13/02 04:50pm'
有误:Select cast('now' as timestamp) from rdb$database;===> '09/13/02 04:50pm'
select @SysDate=GetDate()
例如:
Print convert(varchar(2),datepart(dd,GetDate()))+convert(varchar(2),datepart(hh,GetDate()))
Select Cast('now' as date) from rdb$database;===>
'09/13/02'Select case('now' as timestamp) from rdb$database;===>
'09/13/02 04:50pm'
'09/13/02 04:50pm'