Skip to Content
avatar image
Former Member

Extract Time from Dattime field in IDT

I have datetime field and i wanted to extract only time component from the field. However when i extract time it doesnot show AM/PM in time.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 14 at 11:39 AM

    Use this

    to_char(YOURDATEFIELD,'HH24:MI:SS AM')

    Hope this helps. :)

    Add comment
    10|10000 characters needed characters exceeded