Hi
i want to separate both date and time

what query to use
Select * From Checkin where userid=990 And Timein=4/19/2011???(date Portion only)

and how to retrieve time as well

using dtp1(dtpicker)

table=checkin
user id (text)
Timein (Date/Time)

Userid Timein
989 4/19/2011 2:58:18 PM
990 4/19/2011 3:00:20 PM