Looks like your “TIME” column is defined as a “DATE”, which is fine.
Based on the default date format you will typically only get the date portion of the date/time field. Instead, wrap the TIME column with a to_char, like this:
SELECT to_char(TIME, ‘MM/DD/YYYY HH:MI:SS AM’) my_time_as_char, batch_number, P17, P18
From: kodiak_kid [mailto:firstname.lastname@example.org]
Sent: Saturday, August 05, 2017 12:24 PM
Subject: [Toad for Oracle - Discussion Forum] Toad Script Runner results missing time
Toad Script Runner results missing time
Thread created by kodiak_kid
total newb here, but I did search and it looks like this format is correct. I get all of the data I need except for the time. I get the date, but I also need the time. Am I missing something here? Thanks in advance!
SELECT TIME, batch_number, P17, P18
where cell like ‘%12GD%’ and P18 = ‘Eval’ and TIME between TO_DATE(‘07/18/2017 11:59:00 PM’ , ‘MM/DD/YYYY HH:MI:SS AM’) and TO_DATE(‘08/01/2017 11:59:59 PM’ , ‘MM/DD/YYYY HH:MI:SS AM’);
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.