Not able to find dateTime value using sql

[bimleshsharma]

i am using sql statement to get value of datetime datatype field but it is giving only date instead of complete value. value in table is like

trade_time
11/9/2012 3:19:18.000 PM
11/9/2012 6:33:06.000 PM
11/9/2012 3:19:18.000 PM

but output coming only:

11/9/2012

Here is code i am using.

$original_tradeTime= qx!kfsql -S SERVER -D big -F e -s , -c \"select t
+op 1 *,convert(datetime,trade_time) from trx where trade_id = 123\"!;
   chomp $original_tradeTime;
   $original_tradeTime =~ s/\"//g;
   print "\noriginal_tradeTime=$original_tradeTime";