select current_date, current_time result: Current_Date() Current_Time() 04/15/2011 11:51:37+00:00
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