Trivia question re TO_DATE(SYSDATE)

From: laleonard_SpamBanana_AT_mindspring.com <laleonard_at_mindspring.com>
Date: Fri, 08 Oct 1999 22:02:43 GMT
Message-ID: <7tlplr$92k$1@nnrp1.deja.com>

I think I'm having a problem that I've traced to the use of TO_DATE (SYSDATE). I'm assuming that the correct syntax is just SYSDATE, but I'm curious (a) why does the former work at all, and (b) has anyone experienced problem doing that. TIA.

Oh yeah, the problem is that occasionally the date inserted into the table ends up having its time set as 00:00:00.

--

---

Definitive Solutions, Inc - Makers of AprCalc, the Premier Shareware Mortgage Calculator for Windows. www.DefinitiveSolutions.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 08 1999 - 17:02:43 CDT