游标定义为datetime类型出现的问题
declare   @time   datetime
declare   span   cursor   for   select   curdate   from   curgpsinfo
open   span
fetch   next   from   span   into   @time
begin
print   @time
fetch   next   from   span   into   @time
end
close   span
deallocate   span

curdate字段也是datetime类型的
但是数据库里面是这样的
2007-08-24   16:19:09.000
而我print出来却是
08   24   2007     4:19PM

秒的信息丢失了
如何才能按照原样打印出来啊？

------解决方案--------------------
try

declare @time datetime
declare span cursor for select curdate from curgpsinfo
open span
fetch next from span into @time
begin
print Convert(Varchar, @time, 120)
fetch next from span into @time
end
close span
deallocate span