In Oracle a column of datatype DATE does indeed include both date and time. I do not know how (or why) you would put them in different columns.
When you are updating the column, be sure to update the ENTIRE column, both the date portion and the time portion.
The Oracle function TO_CHAR can be used to access the date portion and the time portion separately or even the DAY potion or the MONTH portion or …
<pre>
SELECT TO_CHAR(SYSDATE, ‘MM/DD/YYYY HH24:MI:SS’) FROM DUAL;
—
— TO_CHAR(SYSDATE,’MM
— ——————-
— 04/20/2004 08:19:54
</pre>
You might also want to take a look at TO_DATE function.
<pre>
SELECT ‘TO DATE’ , TO_DATE(’01/28/2002′,’MM/DD/YYYY’) FROM DUAL;
—
— ‘TODATE TO_DATE(‘
— ——- ———
— TO DATE 28-JAN-02
</pre>
Discuss This Question: 4  Replies