Date Related Problem
Posted on 2003-03-16
I am doing something like date calculation statement. I have some question need to ask.
This is my MSSql data look like
ABC123 2/26/2003 6:31:00 PM
And when I retrieve this data,
I see this
Fine, this output data look fine for me. But when I want to do some sorting on this data (from MSSQL), I add in something in my SQL Statement, like this,
SELECT * FROM table_name WHERE StaffID='SKL' and Date>='2002-01-01'
But end up, it's still list out all the data. Meaning it's doesn't care about the condition that i set Date>='2002-01-02'.
Can anyone tell me how can I set the control in the date side? Let say I only interest on the data started from 2002 January 01??