Re: How to write this function trigger in oracle 9i?

Jim Kennedy wrote:
> [B]Make the field a date field not a text field. You never store
> dates in a
> text field.
> then on insert do to_date(xx,'your format') eg 'mm/dd/yyyy')
> Jim
> "sxbug" <sxbug.12l42b_at_mail.mcse.ms> wrote in message
> news:sxbug.12l42b_at_mail.mcse.ms...[color=blue]
>
> Now I check my DataBase. I have make it Date Field, In Applicate
> Server I use Delphi Query SQLUpdate Component to post data.
>
> In client ,User always post datetime data like 'yyyy-mm-dd hh:mi:ss'
> or 'yyyy-mm-dd' or NULL.
>
> I found DataBase recive all data, but the client application can not
> identify and halt.
> error msg display:invilid time.

--
sxbug
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message447603.html