Re: DATE FORMAT

From: Alan <alanshein_at_erols.com>
Date: Fri, 22 Mar 2002 15:03:57 -0500
Message-ID: <a7g2hi$knpdu$1@ID-114862.news.dfncis.de>

Documenation and manuals are great for this type of question, but as long as you're here...

Just insert the date and don't worry about the time. It will default to 12:00 a.m. unless you specify otherwise or are using SYSDATE, or a date from another field that may have a time other than 12AM.

For exact syntax, RT_M.

"harry smith" <hrysmth_at_hotmail.com> wrote in message news:a7g1ng$l77rv$1_at_ID-135545.news.dfncis.de...
> How do I insert values 'AUG 22 2001 12:00AM'
> into a date datatype field?
>
>
> -hsmith
>
>
>
Received on Fri Mar 22 2002 - 14:03:57 CST