-
I am having a problem with a PL/SQL program returning a date. I have a procedure passing a date in the following format:
to_char(v_date,'fmMonth DD,YYYY:HH24:MI')
but when there is a zero in the hours or minutes it removes the zero. So a date and time that should look like:
April 24, 2001:14:05
but it looks like:
April 24, 2001:14:5
does anyone know how to fix this?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|