Re: help with date insertions

Daniel Morgan wrote:

> What is going on here is a question of display format. Oracle, by
> default displays years as two digits. In fact ALL Oracle dates contain
> day, month, four digit year, hour, minute, and second.
>
> Here's the query you should be writing:
>
> select TO_CHAR(EXPECTED_CLOSURE_DATE, 'DD-MON-YYYY HH:MI:SS')
> FROM risk
> WHERE risk_no = 71;
>
> to see what you have inserted.
>
> Personally I'd never write an insert statement in ASP or any other
> front-end tool. Is is inefficient and just makes the front-end fatter.
> Far better to build a stored procedure that performs the insert, pass it
> the parameters, and have it return a confirming message indicating
> sucess or failure.
>
> But there is nothing wrong with what you've done.

Thanks, it worked.

I am a sort of newbie to Oracle and its version of SQL. I would definitely agree with you on using stored procedures etc. But current scenario of this project doesn't allow me to do that.

Thanks again.

-- 
Yousaf
Linux version 2.4.20-8  
gcc version 3.2.2
Red Hat 9