Skip to main content
Question

i have a column that contains date and time , i only want to have time from that column , how can i get that using pql , Thankyou

  • May 17, 2022
  • 1 reply
  • 8 views
.
Level 3
i have a column that contains date and time , i only want to have time from that column , how can i get that using pql , Thankyou

    1 reply

    .
    Level 8

    Hi Akash ,

    Please do the following.

    -- Type cast datetime to String/char

    -- use substring function to cut from the position till end.

    SUBSTR(to_char(Date_column,'DD-MON-YYYY HH24:MI:SS'),12)

     

    Why 12: This is Position till DD-MON-YYYY (Including Space at end, before HH24).. your actual timestamp starts from 12 location .

     

    Regards

    Ayan

     

    Community Code of ConductAccessibility statement