Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What's the purpose of this SQL statement?
>as the time stamp. If that is, indeed, the case, the following is simpler:
>
>SELECT trunc(SYSDATE) INTO v_date FROM dual;
Simpler, and even more important: Y2k proof!
Arjan. Received on Tue Jul 21 1998 - 23:54:37 CDT
![]() |
![]() |