SELECT * FROM NEW_OUTPUT_UPLOAD_TSN
WHERE To_Date (OUTPUT_UPLOAD_DATE, 'MM/DD/YY HH24:MI:SS')
BETWEEN TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY HH24:MI:SS')
AND TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY HH24:MI:SS')
However, Your "between" dates are the same... NOT a range.
Is this correct?
Also... Your 24 comes AFTER the HH... NOT before.
For future reference, never use a VarChar2 datatype for a date.
You're just asking for problems like you're having now.
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...