Re: Time is cut off from sysdate using PL/SQL

Hello
Peter C. пишет в сообщении <7mk59i$a08$1_at_nnrp1.deja.com> ...
>I discovered that the time part of sysdate is cut of using sysdate in a
>to_date function in a PL/SQL procedure.
>If you first select sysdate into a local variable it doesn't happen.
>Is this a normal behaviour of PL/SQL or more like a bug?

SysDate have datatype DATE and no need converting of TO_DATE If you write
> 5 date1 := SYSDATE;

or
> 5 date1 := TO_DATE(TO_CHAR(SYSDATE,'DD.MM.RRRR HH24:MI:SS'),
'DD.MM.RRRR HH24:MI:SS');
You get full DateTime output

It is normal SQL

Best regards
Всех Благ
---
Origin ... Просто надо очень верить этим синим маякам... Romanov Alexander
Alex_Romanov_at_mail.ru
ICQ 6220754 Received on Thu Jul 15 1999 - 07:47:57 CDT