Skip to Content
0

Extract Time from Dattime field in IDT

May 11 at 07:16 AM

17

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manish Katyal May 14 at 11:39 AM
0

Use this

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

Hope this helps. :)

Share
10 |10000 characters needed characters left characters exceeded