[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Date-Time Command in ORACLE

Paul,
In your INSERT statement use the same date conversion mask:

        TO_DATE(&dttm_stamp,'DD-MON-YYYY HH:MI:SS')
David.


>When I try to insert it I get the error
>ORA-01830: date format picture ends before converting entire input
>string.
>What is the correct mask to insert my value using ORACLE?
>
>date-time () 'DD-MON-YYYY HH:MI:SS' &dttm_stamp