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 | Community

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

Page 1 / 1

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

Reply