Re: database date fields

On Thu, 23 Jul 1998 23:06:49 -0500, Hari Thanigaraj <hari_at_cardsfellow.wustl.edu> wrote:

>A funtion to extract the datepart alone
>from the database field perhaps ?

You can use the TRUNC function to do this. For example:

select trunc(sysdate) from dual;

The above will return only the date, not the time.

Jonathan Received on Sun Jul 26 1998 - 12:39:28 CDT