SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove or Change seconds in Date field

403877Oct 29 2007 — edited Oct 30 2007

Hello All,

I have a field which is storing the start and end time. data type is date ( oracle 8.1.6). while the data is store into the table it is taking seconds also, but the requirement is to store only hours and minutes not seconds. for eg. if the time is '30/10/2007 10:30:59'. How to do this. ?

regards
Kris

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2007

Added on Oct 29 2007

1 comment

3,834 views