select current_date, current_time

result:
	Current_Date()	Current_Time()
	04/15/2011	11:51:37+00:00

current second and microsecond

select  current_timestamp, cast(current_timestamp as varchar(26))

result:
	Current_Timestamp()	Current_Timestamp()
	2011-04-15 14:10:56.160000+00:00	2011-04-15 14:10:56.160000