Join Slack
Powered by
I need to create a saved search showing the IF shi...
# general
s
Simon
01/07/2020, 1:35 PM
I need to create a saved search showing the IF shipped during the day by hours like : Hour Shipped 8:00 10 9:00 15 10:00 20 I'm using the create date but how can I extract/get only the time ?
b
battk
01/07/2020, 1:39 PM
use a formula and TO_CHAR
battk
01/07/2020, 1:39 PM
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions180.htm
battk
01/07/2020, 1:40 PM
use a format which includes a Datetime hour format
battk
01/07/2020, 1:40 PM
https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#sthref412
4
Views
Open in Slack
Previous
Next