How Do I display current date and time in Toad for Oracle?

[Justiin1265]

I have a sql statement that counts the units(cable boxes) that were refurbed(had damaged parts replaced) and total units(cable boxes that just went through refurb and had nothing replaced) and its supposed to do this count regularly, (every time a unit is processed the count). Can someone please help me? Thank you. Justin Heres my sequal code so far: SELECT COUNT(*) FROM cxadminn.repair_part WHERE repair_type = 'REFURB' and created_date >?

[Wendelius]

If you want to get the current date including time you use SYSDATE. For example:

SELECT SYSDATE FROM dual;

But I don't know why would you put SYSDATE in place of the question mark unless you have rows in the table where created date is in the future?

The need to optimize rises from a bad design.My articles[^]

[Jorgen Andersson]

Exchange the ? with a "to_date" function. For example: to_date('2009/07/09', 'yyyy/mm/dd') would return a date value of July 9, 2009. There's more on the formatting here[^]

List of common misconceptions

[Prasanta_Prince]

SELECT current_date FROM dual; or SELECT SYSDATE FROM dual;