From: forbrich@yahoo.net   
      
   ofer_c33@hotmail.com wrote:   
   >   
   > when i put record into table in this format   
   > insert into test(boat_id,strartDate) values(2,to_date('2004-01-02   
   > 16:00:00','YYYY-MM-DD HH24:MI:SS'));   
   >   
   > it is lood ok   
   > but when i try to fet the record out   
   > i see only the date and not the hour   
   >   
   > how can i see the hour???/////   
   >   
   > thanks Ofer   
      
   Why not use a mask, just like you used to put the value in?   
      
   If you read the manuals, you will find this is the default behaviour for   
   date columns.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)