Skip to Main Content

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!

How to set DATE format to 23:59:59.000

user546710Nov 22 2010 — edited Nov 22 2010
Hi all,

Whenever I pass date as parameter, I want to convert into Date + 23:59:59.000.

For example, if i pass 2007-08-18, i want to convert into 2007-08-18 23:59:59.000.

Thanks,
Pal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2010
Added on Nov 22 2010
6 comments
16,469 views