DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Date format problem

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    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?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That's what the FM modifier does...
    http://technet.oracle.com/docs/produ...elem.htm#35390
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width