Re: working with time calculations...

Peet

Assuming the fields in your table are of DATE datatype, use the following:

insert into timesheet
values (to_date('24-JUL-2001 05:57:00', 'DD-MON-YYYY HH24:MI:SS'), to_date('24-JUL-2001 09:05:00', 'DD-MON-YYYY HH24:MI:SS'))

which tells the insert statement to convert the text string against the date map specified. Alternately, set the NLS_DATE_FORMAT to default to the format map that you want to use.

"Trainee DBA" <xxx_at_hotmail.com> wrote in message news:HRe77.13237$a04.45753_at_newsfeeds.bigpond.com...
> I'm trying to build a simple time keeping application... I'm stuck on
 basic
> calculations with time.
> I have created a table with 2 date fields, where i want to insert start
 and
> stop times.
> Later I want to build a view that subtract one from the other and
 calculate
> the time in hours and minutes.
>
> My attempt so far of:
>
> insert into timesheet
> values ('24-JUL-2001 05:57:00', '24-JUL-2001 09:5:00')
>
> Doesn't seem to work... I get the error:
>
> ERROR at line 2:
> ORA-01830: date format picture ends before converting entire input string
>
> The SQLA course covers arithmetic with dates, which I 'm happy enough
> with... but how do you enter a specific date + time into a date field?
>
> If anybody could offer some help or a better way of doing this Id really
> appreciate the help. Thanks
>
>
> Peet
>
>
Received on Tue Jul 24 2001 - 09:56:46 CDT