Re: quickie on sysdate

Try:
select to_char(sysdate,'MM/DD/YYYY') from dual;

David de Gendt wrote:

> I need to insert a date in a field: How can format sysdate to only format
> the string as date (without the time)